/// <summary> /// 增加一条数据 /// </summary> public bool Add(YJUI.Model.shiwu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into shiwu("); strSql.Append("fkDate,fkPerson,supportDep,fkDesc)"); strSql.Append(" values ("); strSql.Append("@fkDate,@fkPerson,@supportDep,@fkDesc)"); SqlParameter[] parameters = { new SqlParameter("@fkDate", SqlDbType.DateTime), new SqlParameter("@fkPerson", SqlDbType.VarChar, 50), new SqlParameter("@supportDep", SqlDbType.VarChar, 50), new SqlParameter("@fkDesc", SqlDbType.Text) }; parameters[0].Value = model.fkDate; parameters[1].Value = model.fkPerson; parameters[2].Value = model.supportDep; parameters[3].Value = model.fkDesc; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 满意评价操作 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool PingJia(YJUI.Model.shiwu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shiwu set "); strSql.Append("myPingjia=@myPingjia,"); strSql.Append("myPerson=@myPerson,"); strSql.Append("myDate=@myDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@myPingjia", SqlDbType.VarChar, 50), new SqlParameter("@myPerson", SqlDbType.VarChar, 50), new SqlParameter("@myDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.myPingjia; parameters[1].Value = model.myPerson; parameters[2].Value = model.myDate; parameters[3].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 领导检核 /// </summary> public bool Jianhe(YJUI.Model.shiwu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shiwu set "); strSql.Append("lsResult=@lsResult,"); strSql.Append("lsDep=@lsDep,"); strSql.Append("lsDate=@lsDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@lsResult", SqlDbType.VarChar, 100), new SqlParameter("@lsDep", SqlDbType.Char, 10), new SqlParameter("@lsDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.lsResult; parameters[1].Value = model.lsDep; parameters[2].Value = model.lsDate; parameters[3].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 问题处理 /// </summary> public bool Chuli(YJUI.Model.shiwu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shiwu set "); strSql.Append("receiveDep=@receiveDep,"); strSql.Append("receivePerson=@receivePerson,"); strSql.Append("receiveDate=@receiveDate,"); strSql.Append("tempGaishan=@tempGaishan,"); strSql.Append("cqFangan=@cqFangan,"); strSql.Append("cqDate=@cqDate,"); strSql.Append("endDate=@endDate "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@receiveDep", SqlDbType.VarChar, 50), new SqlParameter("@receivePerson", SqlDbType.VarChar, 50), new SqlParameter("@receiveDate", SqlDbType.DateTime), new SqlParameter("@tempGaishan", SqlDbType.NVarChar, 200), new SqlParameter("@cqFangan", SqlDbType.NVarChar, 200), new SqlParameter("@cqDate", SqlDbType.DateTime), new SqlParameter("@endDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.receiveDep; parameters[1].Value = model.receivePerson; parameters[2].Value = model.receiveDate; parameters[3].Value = model.tempGaishan; parameters[4].Value = model.cqFangan; parameters[5].Value = model.cqDate; parameters[6].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YJUI.Model.shiwu GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,fkDate,fkPerson,supportDep,fkDesc,receiveDep,receivePerson,receiveDate,tempGaishan,cqFangan,cqDate,endDesc,endDate,lsResult,lsDep,lsDate,myPingjia,myPerson,myDate,dsJianhe,dsPerson,dsDate from shiwu "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; YJUI.Model.shiwu model = new YJUI.Model.shiwu(); 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 bool Update(YJUI.Model.shiwu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shiwu set "); strSql.Append("fkDate=@fkDate,"); strSql.Append("fkPerson=@fkPerson,"); strSql.Append("supportDep=@supportDep,"); strSql.Append("fkDesc=@fkDesc,"); strSql.Append("receiveDep=@receiveDep,"); strSql.Append("receivePerson=@receivePerson,"); strSql.Append("receiveDate=@receiveDate,"); strSql.Append("tempGaishan=@tempGaishan,"); strSql.Append("cqFangan=@cqFangan,"); strSql.Append("cqDate=@cqDate,"); strSql.Append("endDesc=@endDesc,"); strSql.Append("endDate=@endDate,"); strSql.Append("lsResult=@lsResult,"); strSql.Append("lsDep=@lsDep,"); strSql.Append("lsDate=@lsDate,"); strSql.Append("myPingjia=@myPingjia,"); strSql.Append("myPerson=@myPerson,"); strSql.Append("myDate=@myDate,"); strSql.Append("dsJianhe=@dsJianhe,"); strSql.Append("dsPerson=@dsPerson,"); strSql.Append("dsDate=@dsDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@fkDate", SqlDbType.DateTime), new SqlParameter("@fkPerson", SqlDbType.VarChar, 50), new SqlParameter("@supportDep", SqlDbType.VarChar, 50), new SqlParameter("@fkDesc", SqlDbType.Text), new SqlParameter("@receiveDep", SqlDbType.VarChar, 50), new SqlParameter("@receivePerson", SqlDbType.VarChar, 50), new SqlParameter("@receiveDate", SqlDbType.DateTime), new SqlParameter("@tempGaishan", SqlDbType.NVarChar, 200), new SqlParameter("@cqFangan", SqlDbType.NVarChar, 200), new SqlParameter("@cqDate", SqlDbType.DateTime), new SqlParameter("@endDesc", SqlDbType.Text), new SqlParameter("@endDate", SqlDbType.VarChar, 50), new SqlParameter("@lsResult", SqlDbType.VarChar, 100), new SqlParameter("@lsDep", SqlDbType.Char, 10), new SqlParameter("@lsDate", SqlDbType.DateTime), new SqlParameter("@myPingjia", SqlDbType.VarChar, 50), new SqlParameter("@myPerson", SqlDbType.VarChar, 50), new SqlParameter("@myDate", SqlDbType.DateTime), 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.fkDate; parameters[1].Value = model.fkPerson; parameters[2].Value = model.supportDep; parameters[3].Value = model.fkDesc; parameters[4].Value = model.receiveDep; parameters[5].Value = model.receivePerson; parameters[6].Value = model.receiveDate; parameters[7].Value = model.tempGaishan; parameters[8].Value = model.cqFangan; parameters[9].Value = model.cqDate; parameters[10].Value = model.endDesc; parameters[11].Value = model.endDate; parameters[12].Value = model.lsResult; parameters[13].Value = model.lsDep; parameters[14].Value = model.lsDate; parameters[15].Value = model.myPingjia; parameters[16].Value = model.myPerson; parameters[17].Value = model.myDate; parameters[18].Value = model.dsJianhe; parameters[19].Value = model.dsPerson; parameters[20].Value = model.dsDate; parameters[21].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YJUI.Model.shiwu DataRowToModel(DataRow row) { YJUI.Model.shiwu model = new YJUI.Model.shiwu(); 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["supportDep"] != null) { model.supportDep = row["supportDep"].ToString(); } if (row["fkDesc"] != null) { model.fkDesc = row["fkDesc"].ToString(); } if (row["receiveDep"] != null) { model.receiveDep = row["receiveDep"].ToString(); } if (row["receivePerson"] != null) { model.receivePerson = row["receivePerson"].ToString(); } if (row["receiveDate"] != null && row["receiveDate"].ToString() != "") { model.receiveDate = DateTime.Parse(row["receiveDate"].ToString()); } if (row["tempGaishan"] != null) { model.tempGaishan = row["tempGaishan"].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["endDesc"] != null) { model.endDesc = row["endDesc"].ToString(); } if (row["endDate"] != null) { model.endDate = row["endDate"].ToString(); } if (row["lsResult"] != null) { model.lsResult = row["lsResult"].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); }