private int UpdateT002SiireData()
{
// SQL
var sbSQL = new StringBuilder();
sbSQL.AppendLine(" UPDATE ZHT003 SET ");
sbSQL.AppendLine(" STATUS =:STATUS ");
sbSQL.AppendLine(" ,BIKO =:BIKO");
sbSQL.AppendLine(" ,SAGYO_FLG =:SAGYOFLG");
sbSQL.AppendLine(" ,UPD_DATE =:UPDDATE");
sbSQL.AppendLine(" ,UPD_CD =:UPDCD");
sbSQL.AppendLine(" ,UPD_PG =:UPDPG");
sbSQL.AppendLine(" ,UPD_PC =:UPDPC");
sbSQL.AppendLine(" ,UPD_CNT = UPD_CNT + 1");
sbSQL.AppendLine(" WHERE JUCHU_KANRI_NO = :JUCHU_KANRI_NO ");
sbSQL.AppendLine(" AND HACHU_MEISAI_NO = :HACHU_MEISAI_NO ");
sbSQL.AppendLine(" AND HACHU_NO = :HACHUNO ");
sbSQL.AppendLine(" AND BUNNO_NO = :BUNNONO ");
sbSQL.AppendLine(" AND REN_NO = :RENNO ");
// 执行
var cmd = new OracleCommand();
cmd.Connection = this.DbConnection;
cmd.BindByName = true;
cmd.CommandText = sbSQL.ToString();
cmd.ArrayBindCount = dsMeisai.Z6030010_02.Count;
// 下边一句是最主要得语句
var rows = dsMeisai.Z6030010_02.AsEnumerable();
cmd.Parameters.Add(":STATUS", OracleDbType.Char).Value = rows.Select(r => r.STATUS).ToArray();
cmd.Parameters.Add(":BIKO", OracleDbType.Char).Value = rows.Select(r => r.BIKO).ToArray();
cmd.Parameters.Add(":SAGYOFLG", OracleDbType.Char).Value = rows.Select(r => r.SAGYOFLG).ToArray();
cmd.Parameters.Add(":JUCHU_KANRI_NO", OracleDbType.Char).Value = rows.Select(r => r.JUCHUKANRINO).ToArray();
cmd.Parameters.Add(":HACHU_MEISAI_NO", OracleDbType.Char).Value = rows.Select(r => r.HACHUMEISAINO).ToArray();
cmd.Parameters.Add(":HACHUNO", OracleDbType.Char).Value = rows.Select(r => r.HACHUNO).ToArray();
cmd.Parameters.Add(":BUNNONO", OracleDbType.Char).Value = rows.Select(r => r.BUNNONO).ToArray();
cmd.Parameters.Add(":RENNO", OracleDbType.Char).Value = rows.Select(r => r.RENNO).ToArray();
cmd.Parameters.Add(":UPDDATE", OracleDbType.Char).Value = rows.Select(r => r.UPDDATE).ToArray();
cmd.Parameters.Add(":UPDCD", OracleDbType.Char).Value = rows.Select(r => r.UPDCD).ToArray();
cmd.Parameters.Add(":UPDPG", OracleDbType.Char).Value = rows.Select(r => r.UPDPG).ToArray();
cmd.Parameters.Add(":UPDPC", OracleDbType.Char).Value = rows.Select(r => r.UPDPC).ToArray();
if (cmd.ArrayBindCount == 0)
return 0;
return cmd.ExecuteNonQuery();
}
### 最主要的C#语句是:
var rows = dsMeisai.Z6030010_02.AsEnumerable();
### lamda表达式
r => r.UPDPC ,这个r相当于是数据源中的DataSet ,通过数据源来获取每一条数据中的对应的值,从而进行赋值