/// <summary> /// 第三方检核 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update_disanfangjianhe(YJUI.Model.neibutaizhang model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update neibutaizhang set "); strSql.Append("dsJianhe=@dsJianhe,"); strSql.Append("dsPerson=@dsPerson,"); strSql.Append("dsDate=@dsDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@dsJianhe", SqlDbType.VarChar, 50), new SqlParameter("@dsPerson", SqlDbType.VarChar, 50), new SqlParameter("@dsDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.dsJianhe; parameters[1].Value = model.dsPerson; parameters[2].Value = model.dsDate; parameters[3].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(YJUI.Model.neibutaizhang model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update neibutaizhang set "); strSql.Append("dyDep=@dyDep,"); strSql.Append("dyPerson=@dyPerson,"); strSql.Append("dyDate=@dyDate,"); strSql.Append("dyGaishan=@dyGaishan,"); strSql.Append("cqFangan=@cqFangan,"); strSql.Append("IsEnd=@IsEnd,"); strSql.Append("cqDate=@cqDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@dyDep", SqlDbType.VarChar, 50), new SqlParameter("@dyPerson", SqlDbType.VarChar, 50), new SqlParameter("@dyDate", SqlDbType.DateTime), new SqlParameter("@dyGaishan", SqlDbType.NVarChar, 200), new SqlParameter("@cqFangan", SqlDbType.NVarChar, 200), new SqlParameter("@IsEnd", SqlDbType.NVarChar, 50), new SqlParameter("@cqDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.dyDep; parameters[1].Value = model.dyPerson; parameters[2].Value = model.dyDate; parameters[3].Value = model.dyGaishan; parameters[4].Value = model.cqFangan; parameters[5].Value = model.IsEnd; parameters[6].Value = model.cqDate; parameters[7].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(YJUI.Model.neibutaizhang model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into neibutaizhang("); strSql.Append("fkDate,fkPerson,fkDep,wtDep,fkDesc,fkItem,fkArea,fkCustomer,fkPic,DepCat)"); strSql.Append(" values ("); strSql.Append("@fkDate,@fkPerson,@fkDep,@wtDep,@fkDesc,@fkItem,@fkArea,@fkCustomer,@fkPic,@DepCat)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@fkDate", SqlDbType.DateTime), new SqlParameter("@fkPerson", SqlDbType.VarChar, 50), new SqlParameter("@fkDep", SqlDbType.VarChar, 50), new SqlParameter("@wtDep", SqlDbType.VarChar, 50), new SqlParameter("@fkDesc", SqlDbType.Text), new SqlParameter("@fkItem", SqlDbType.VarChar, 50), new SqlParameter("@fkArea", SqlDbType.VarChar, 200), new SqlParameter("@fkCustomer", SqlDbType.VarChar, 200), new SqlParameter("@fkPic", SqlDbType.VarChar, 200), new SqlParameter("@DepCat", SqlDbType.VarChar, 200), }; parameters[0].Value = model.fkDate; parameters[1].Value = model.fkPerson; parameters[2].Value = model.FkDep; parameters[3].Value = model.wtDep; parameters[4].Value = model.fkDesc; parameters[5].Value = model.fkItem; parameters[6].Value = model.fkArea; parameters[7].Value = model.fkCustomer; parameters[8].Value = model.FkPic; parameters[9].Value = model.DepCat; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YJUI.Model.neibutaizhang GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,fkDate,fkPerson,wtDep,fkDesc,dyDep,dyPerson,dyDate,dyGaishan,cqFangan,cqDate,lsJianhe,lsDep,lsDate,myPingjia,myPerson,myDate,dsJianhe,dsPerson,dsDate from neibutaizhang "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; YJUI.Model.neibutaizhang model = new YJUI.Model.neibutaizhang(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YJUI.Model.neibutaizhang DataRowToModel(DataRow row) { YJUI.Model.neibutaizhang model = new YJUI.Model.neibutaizhang(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["fkDate"] != null && row["fkDate"].ToString() != "") { model.fkDate = DateTime.Parse(row["fkDate"].ToString()); } if (row["fkPerson"] != null) { model.fkPerson = row["fkPerson"].ToString(); } if (row["wtDep"] != null) { model.wtDep = row["wtDep"].ToString(); } if (row["fkDesc"] != null) { model.fkDesc = row["fkDesc"].ToString(); } if (row["dyDep"] != null) { model.dyDep = row["dyDep"].ToString(); } if (row["dyPerson"] != null) { model.dyPerson = row["dyPerson"].ToString(); } if (row["dyDate"] != null && row["dyDate"].ToString() != "") { model.dyDate = DateTime.Parse(row["dyDate"].ToString()); } if (row["dyGaishan"] != null) { model.dyGaishan = row["dyGaishan"].ToString(); } if (row["cqFangan"] != null) { model.cqFangan = row["cqFangan"].ToString(); } if (row["cqDate"] != null && row["cqDate"].ToString() != "") { model.cqDate = DateTime.Parse(row["cqDate"].ToString()); } if (row["lsJianhe"] != null) { model.lsJianhe = row["lsJianhe"].ToString(); } if (row["lsDep"] != null) { model.lsDep = row["lsDep"].ToString(); } if (row["lsDate"] != null && row["lsDate"].ToString() != "") { model.lsDate = DateTime.Parse(row["lsDate"].ToString()); } if (row["myPingjia"] != null) { model.myPingjia = row["myPingjia"].ToString(); } if (row["myPerson"] != null) { model.myPerson = row["myPerson"].ToString(); } if (row["myDate"] != null && row["myDate"].ToString() != "") { model.myDate = DateTime.Parse(row["myDate"].ToString()); } if (row["dsJianhe"] != null) { model.dsJianhe = row["dsJianhe"].ToString(); } if (row["dsPerson"] != null) { model.dsPerson = row["dsPerson"].ToString(); } if (row["dsDate"] != null && row["dsDate"].ToString() != "") { model.dsDate = DateTime.Parse(row["dsDate"].ToString()); } } return(model); }