/// <summary> /// 更新一条数据 /// </summary> public bool Update(CJH.Model.Job_CardInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Job_CardInfo set "); strSql.Append("Job_Code=@Job_Code,"); strSql.Append("Customer=@Customer,"); strSql.Append("State=@State,"); strSql.Append("SCID=@SCID,"); strSql.Append("CAID=@CAID,"); strSql.Append("Board=@Board,"); strSql.Append("Address=@Address,"); strSql.Append("Open_Time=@Open_Time"); strSql.Append(" where HHT_ID=@HHT_ID "); SqlParameter[] parameters = { new SqlParameter("@Job_Code", SqlDbType.NVarChar, 30), new SqlParameter("@Customer", SqlDbType.NVarChar, 10), new SqlParameter("@State", SqlDbType.NVarChar, 10), new SqlParameter("@SCID", SqlDbType.NVarChar, 12), new SqlParameter("@CAID", SqlDbType.NVarChar, 11), new SqlParameter("@Board", SqlDbType.NVarChar, 30), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@Open_Time", SqlDbType.DateTime), new SqlParameter("@HHT_ID", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.Job_Code; parameters[1].Value = model.Customer; parameters[2].Value = model.State; parameters[3].Value = model.SCID; parameters[4].Value = model.CAID; parameters[5].Value = model.Board; parameters[6].Value = model.Address; parameters[7].Value = model.Open_Time; parameters[8].Value = model.HHT_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CJH.Model.Job_CardInfo DataRowToModel(DataRow row) { CJH.Model.Job_CardInfo model = new CJH.Model.Job_CardInfo(); if (row != null) { if (row["Job_Code"] != null) { model.Job_Code = row["Job_Code"].ToString(); } if (row["HHT_ID"] != null) { model.HHT_ID = row["HHT_ID"].ToString(); } if (row["Customer"] != null) { model.Customer = row["Customer"].ToString(); } if (row["State"] != null) { model.State = row["State"].ToString(); } if (row["SCID"] != null) { model.SCID = row["SCID"].ToString(); } if (row["CAID"] != null) { model.CAID = row["CAID"].ToString(); } if (row["Board"] != null) { model.Board = row["Board"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["Open_Time"] != null && row["Open_Time"].ToString() != "") { model.Open_Time = DateTime.Parse(row["Open_Time"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(CJH.Model.Job_CardInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Job_CardInfo("); strSql.Append("Job_Code,HHT_ID,Customer,State,SCID,CAID,Board,Address,Open_Time)"); strSql.Append(" values ("); strSql.Append("@Job_Code,@HHT_ID,@Customer,@State,@SCID,@CAID,@Board,@Address,@Open_Time)"); SqlParameter[] parameters = { new SqlParameter("@Job_Code", SqlDbType.NVarChar, 30), new SqlParameter("@HHT_ID", SqlDbType.NVarChar, 20), new SqlParameter("@Customer", SqlDbType.NVarChar, 10), new SqlParameter("@State", SqlDbType.NVarChar, 10), new SqlParameter("@SCID", SqlDbType.NVarChar, 12), new SqlParameter("@CAID", SqlDbType.NVarChar, 11), new SqlParameter("@Board", SqlDbType.NVarChar, 30), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@Open_Time", SqlDbType.DateTime) }; parameters[0].Value = model.Job_Code; parameters[1].Value = model.HHT_ID; parameters[2].Value = model.Customer; parameters[3].Value = model.State; parameters[4].Value = model.SCID; parameters[5].Value = model.CAID; parameters[6].Value = model.Board; parameters[7].Value = model.Address; parameters[8].Value = model.Open_Time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CJH.Model.Job_CardInfo GetModel(string HHT_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Job_Code,HHT_ID,Customer,State,SCID,CAID,Board,Address,Open_Time from Job_CardInfo "); strSql.Append(" where HHT_ID=@HHT_ID "); SqlParameter[] parameters = { new SqlParameter("@HHT_ID", SqlDbType.NVarChar, 20) }; parameters[0].Value = HHT_ID; CJH.Model.Job_CardInfo model = new CJH.Model.Job_CardInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }