/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_SeZJB_PDD_FINISHED model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SeZJB_PDD_FINISHED("); strSql.Append("ysdh,ck,pdrq,djzt,shuser,shdate,finished,ZJBstatus,ts,by1,by2,by3,by4,by5)"); strSql.Append(" values ("); strSql.Append("@ysdh,@ck,@pdrq,@djzt,@shuser,@shdate,@finished,@ZJBstatus,@ts,@by1,@by2,@by3,@by4,@by5)"); SqlParameter[] parameters = { new SqlParameter("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 20), new SqlParameter("@pdrq", SqlDbType.DateTime), new SqlParameter("@djzt", SqlDbType.VarChar, 10), new SqlParameter("@shuser", SqlDbType.VarChar, 20), new SqlParameter("@shdate", SqlDbType.DateTime), new SqlParameter("@finished", SqlDbType.Int, 4), 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.ysdh; parameters[1].Value = model.ck; parameters[2].Value = model.pdrq; parameters[3].Value = model.djzt; parameters[4].Value = model.shuser; parameters[5].Value = model.shdate; parameters[6].Value = model.finished; parameters[7].Value = model.ZJBstatus; parameters[8].Value = model.ts; parameters[9].Value = model.by1; parameters[10].Value = model.by2; parameters[11].Value = model.by3; parameters[12].Value = model.by4; parameters[13].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_SeZJB_PDD_FINISHED GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ysdh,ck,pdrq,djzt,shuser,shdate,finished,ZJBstatus,ts,by1,by2,by3,by4,by5 from SeZJB_PDD_FINISHED "); strSql.Append(" where "); SqlParameter[] parameters = { }; Mod_SeZJB_PDD_FINISHED model = new Mod_SeZJB_PDD_FINISHED(); 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 bool Update(Mod_SeZJB_PDD_FINISHED model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SeZJB_PDD_FINISHED set "); strSql.Append("ysdh=@ysdh,"); strSql.Append("ck=@ck,"); strSql.Append("pdrq=@pdrq,"); strSql.Append("djzt=@djzt,"); strSql.Append("shuser=@shuser,"); strSql.Append("shdate=@shdate,"); strSql.Append("finished=@finished,"); 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("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 20), new SqlParameter("@pdrq", SqlDbType.DateTime), new SqlParameter("@djzt", SqlDbType.VarChar, 10), new SqlParameter("@shuser", SqlDbType.VarChar, 20), new SqlParameter("@shdate", SqlDbType.DateTime), new SqlParameter("@finished", SqlDbType.Int, 4), 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.ysdh; parameters[1].Value = model.ck; parameters[2].Value = model.pdrq; parameters[3].Value = model.djzt; parameters[4].Value = model.shuser; parameters[5].Value = model.shdate; parameters[6].Value = model.finished; parameters[7].Value = model.ZJBstatus; parameters[8].Value = model.ts; parameters[9].Value = model.by1; parameters[10].Value = model.by2; parameters[11].Value = model.by3; parameters[12].Value = model.by4; parameters[13].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_SeZJB_PDD_FINISHED DataRowToModel(DataRow row) { Mod_SeZJB_PDD_FINISHED model = new Mod_SeZJB_PDD_FINISHED(); if (row != null) { if (row["ysdh"] != null) { model.ysdh = row["ysdh"].ToString(); } if (row["ck"] != null) { model.ck = row["ck"].ToString(); } if (row["pdrq"] != null && row["pdrq"].ToString() != "") { model.pdrq = DateTime.Parse(row["pdrq"].ToString()); } if (row["djzt"] != null) { model.djzt = row["djzt"].ToString(); } if (row["shuser"] != null) { model.shuser = row["shuser"].ToString(); } if (row["shdate"] != null && row["shdate"].ToString() != "") { model.shdate = DateTime.Parse(row["shdate"].ToString()); } if (row["finished"] != null && row["finished"].ToString() != "") { model.finished = int.Parse(row["finished"].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); }