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