/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_SeZJB_Shift_Record model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SeZJB_Shift_Record set "); strSql.Append("ywdh=@ywdh,"); strSql.Append("ck=@ck,"); strSql.Append("shw=@shw,"); strSql.Append("dhw=@dhw,"); strSql.Append("czry=@czry,"); strSql.Append("czrq=@czrq,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("ts=@ts,"); strSql.Append("by1=@by1,"); strSql.Append("by2=@by2,"); strSql.Append("by3=@by3,"); strSql.Append("by4=@by4,"); strSql.Append("by5=@by5"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@ywdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@shw", SqlDbType.VarChar, 50), new SqlParameter("@dhw", SqlDbType.VarChar, 50), new SqlParameter("@czry", SqlDbType.VarChar, 50), new SqlParameter("@czrq", SqlDbType.DateTime), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ywdh; parameters[1].Value = model.ck; parameters[2].Value = model.shw; parameters[3].Value = model.dhw; parameters[4].Value = model.czry; parameters[5].Value = model.czrq; parameters[6].Value = model.ZJBstatus; parameters[7].Value = model.ts; parameters[8].Value = model.by1; parameters[9].Value = model.by2; parameters[10].Value = model.by3; parameters[11].Value = model.by4; parameters[12].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_SeZJB_Shift_Record model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SeZJB_Shift_Record("); strSql.Append("ywdh,ck,shw,dhw,czry,czrq,ZJBstatus,ts,by1,by2,by3,by4,by5)"); strSql.Append(" values ("); strSql.Append("@ywdh,@ck,@shw,@dhw,@czry,@czrq,@ZJBstatus,@ts,@by1,@by2,@by3,@by4,@by5)"); SqlParameter[] parameters = { new SqlParameter("@ywdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@shw", SqlDbType.VarChar, 50), new SqlParameter("@dhw", SqlDbType.VarChar, 50), new SqlParameter("@czry", SqlDbType.VarChar, 50), new SqlParameter("@czrq", SqlDbType.DateTime), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ywdh; parameters[1].Value = model.ck; parameters[2].Value = model.shw; parameters[3].Value = model.dhw; parameters[4].Value = model.czry; parameters[5].Value = model.czrq; parameters[6].Value = model.ZJBstatus; parameters[7].Value = model.ts; parameters[8].Value = model.by1; parameters[9].Value = model.by2; parameters[10].Value = model.by3; parameters[11].Value = model.by4; parameters[12].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_SeZJB_Shift_Record GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ywdh,ck,shw,dhw,czry,czrq,ZJBstatus,ts,by1,by2,by3,by4,by5 from SeZJB_Shift_Record "); strSql.Append(" where "); SqlParameter[] parameters = { }; Mod_SeZJB_Shift_Record model = new Mod_SeZJB_Shift_Record(); DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_SeZJB_Shift_Record DataRowToModel(DataRow row) { Mod_SeZJB_Shift_Record model = new Mod_SeZJB_Shift_Record(); if (row != null) { if (row["ywdh"] != null) { model.ywdh = row["ywdh"].ToString(); } if (row["ck"] != null) { model.ck = row["ck"].ToString(); } if (row["shw"] != null) { model.shw = row["shw"].ToString(); } if (row["dhw"] != null) { model.dhw = row["dhw"].ToString(); } if (row["czry"] != null) { model.czry = row["czry"].ToString(); } if (row["czrq"] != null && row["czrq"].ToString() != "") { model.czrq = DateTime.Parse(row["czrq"].ToString()); } if (row["ZJBstatus"] != null && row["ZJBstatus"].ToString() != "") { model.ZJBstatus = int.Parse(row["ZJBstatus"].ToString()); } if (row["ts"] != null && row["ts"].ToString() != "") { model.ts = DateTime.Parse(row["ts"].ToString()); } if (row["by1"] != null) { model.by1 = row["by1"].ToString(); } if (row["by2"] != null) { model.by2 = row["by2"].ToString(); } if (row["by3"] != null) { model.by3 = row["by3"].ToString(); } if (row["by4"] != null) { model.by4 = row["by4"].ToString(); } if (row["by5"] != null) { model.by5 = row["by5"].ToString(); } } return(model); }