/// <summary> /// 进行评分 /// </summary> /// <param name="id"></param> /// <param name="score"></param> /// <param name="scorereason"></param> /// <returns></returns> public bool UpdateScore(JMP.MDL.jmp_workorder mode) { StringBuilder strSql = new StringBuilder(); strSql.Append(" update jmp_workorder set [score]=@score,[scorereason]=@scorereason "); strSql.Append(" where id =@id "); SqlParameter[] s = { new SqlParameter("@score", mode.score), new SqlParameter("@scorereason", mode.scorereason), new SqlParameter("@id", mode.id) }; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), s); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> public List <JMP.MDL.jmp_workorder> DataTableToList(DataTable dt) { List <JMP.MDL.jmp_workorder> modelList = new List <JMP.MDL.jmp_workorder>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { JMP.MDL.jmp_workorder model; for (int n = 0; n < rowsCount; n++) { model = new JMP.MDL.jmp_workorder(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["viewcount"].ToString() != "") { model.viewcount = int.Parse(dt.Rows[n]["viewcount"].ToString()); } if (dt.Rows[n]["latestviewdate"].ToString() != "") { model.latestviewdate = DateTime.Parse(dt.Rows[n]["latestviewdate"].ToString()); } if (dt.Rows[n]["score"].ToString() != "") { model.score = int.Parse(dt.Rows[n]["score"].ToString()); } if (dt.Rows[n]["pushedremind"].ToString() != "") { if ((dt.Rows[n]["pushedremind"].ToString() == "1") || (dt.Rows[n]["pushedremind"].ToString().ToLower() == "true")) { model.pushedremind = true; } else { model.pushedremind = false; } } if (dt.Rows[n]["pushreminddate"].ToString() != "") { model.pushreminddate = DateTime.Parse(dt.Rows[n]["pushreminddate"].ToString()); } model.closereason = dt.Rows[n]["closereason"].ToString(); model.initiatorreason = dt.Rows[n]["initiatorreason"].ToString(); model.handlerreason = dt.Rows[n]["handlerreason"].ToString(); model.result = dt.Rows[n]["result"].ToString(); if (dt.Rows[n]["catalog"].ToString() != "") { model.catalog = int.Parse(dt.Rows[n]["catalog"].ToString()); } model.title = dt.Rows[n]["title"].ToString(); model.content = dt.Rows[n]["content"].ToString(); if (dt.Rows[n]["status"].ToString() != "") { model.status = int.Parse(dt.Rows[n]["status"].ToString()); } if (dt.Rows[n]["progress"].ToString() != "") { model.progress = int.Parse(dt.Rows[n]["progress"].ToString()); } if (dt.Rows[n]["createdon"].ToString() != "") { model.createdon = DateTime.Parse(dt.Rows[n]["createdon"].ToString()); } if (dt.Rows[n]["createdbyid"].ToString() != "") { model.createdbyid = int.Parse(dt.Rows[n]["createdbyid"].ToString()); } model.watchidsoftheday = dt.Rows[n]["watchidsoftheday"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_workorder model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_workorder model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_workorder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_workorder("); strSql.Append("viewcount,latestviewdate,score,pushedremind,pushreminddate,closereason,initiatorreason,handlerreason,result,catalog,title,content,status,progress,createdon,createdbyid,watchidsoftheday,resultDate"); strSql.Append(") values ("); strSql.Append("@viewcount,@latestviewdate,@score,@pushedremind,@pushreminddate,@closereason,@initiatorreason,@handlerreason,@result,@catalog,@title,@content,@status,@progress,@createdon,@createdbyid,@watchidsoftheday,@resultDate"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@viewcount", SqlDbType.Int, 4), new SqlParameter("@latestviewdate", SqlDbType.DateTime), new SqlParameter("@score", SqlDbType.Int, 4), new SqlParameter("@pushedremind", SqlDbType.Bit, 1), new SqlParameter("@pushreminddate", SqlDbType.DateTime), new SqlParameter("@closereason", SqlDbType.NVarChar, -1), new SqlParameter("@initiatorreason", SqlDbType.NVarChar, -1), new SqlParameter("@handlerreason", SqlDbType.NVarChar, -1), new SqlParameter("@result", SqlDbType.NVarChar, 255), new SqlParameter("@catalog", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 255), new SqlParameter("@content", SqlDbType.NVarChar, -1), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@progress", SqlDbType.Int, 4), new SqlParameter("@createdon", SqlDbType.DateTime), new SqlParameter("@createdbyid", SqlDbType.Int, 4), new SqlParameter("@watchidsoftheday", SqlDbType.NVarChar, 255), new SqlParameter("@resultDate", SqlDbType.DateTime) }; parameters[0].Value = model.viewcount; parameters[1].Value = model.latestviewdate; parameters[2].Value = model.score; parameters[3].Value = model.pushedremind; parameters[4].Value = model.pushreminddate; parameters[5].Value = model.closereason; parameters[6].Value = model.initiatorreason; parameters[7].Value = model.handlerreason; parameters[8].Value = model.result; parameters[9].Value = model.catalog; parameters[10].Value = model.title; parameters[11].Value = model.content; parameters[12].Value = model.status; parameters[13].Value = model.progress; parameters[14].Value = model.createdon; parameters[15].Value = model.createdbyid; parameters[16].Value = model.watchidsoftheday; parameters[17].Value = model.resultDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_workorder GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, viewcount, latestviewdate, score, pushedremind, pushreminddate, closereason, initiatorreason, handlerreason, result, catalog, title, content, status, progress, createdon, createdbyid, watchidsoftheday "); strSql.Append(" from jmp_workorder "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; JMP.MDL.jmp_workorder model = new JMP.MDL.jmp_workorder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["viewcount"].ToString() != "") { model.viewcount = int.Parse(ds.Tables[0].Rows[0]["viewcount"].ToString()); } if (ds.Tables[0].Rows[0]["latestviewdate"].ToString() != "") { model.latestviewdate = DateTime.Parse(ds.Tables[0].Rows[0]["latestviewdate"].ToString()); } if (ds.Tables[0].Rows[0]["score"].ToString() != "") { model.score = int.Parse(ds.Tables[0].Rows[0]["score"].ToString()); } if (ds.Tables[0].Rows[0]["pushedremind"].ToString() != "") { if ((ds.Tables[0].Rows[0]["pushedremind"].ToString() == "1") || (ds.Tables[0].Rows[0]["pushedremind"].ToString().ToLower() == "true")) { model.pushedremind = true; } else { model.pushedremind = false; } } if (ds.Tables[0].Rows[0]["pushreminddate"].ToString() != "") { model.pushreminddate = DateTime.Parse(ds.Tables[0].Rows[0]["pushreminddate"].ToString()); } model.closereason = ds.Tables[0].Rows[0]["closereason"].ToString(); model.initiatorreason = ds.Tables[0].Rows[0]["initiatorreason"].ToString(); model.handlerreason = ds.Tables[0].Rows[0]["handlerreason"].ToString(); model.result = ds.Tables[0].Rows[0]["result"].ToString(); if (ds.Tables[0].Rows[0]["catalog"].ToString() != "") { model.catalog = int.Parse(ds.Tables[0].Rows[0]["catalog"].ToString()); } model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.content = ds.Tables[0].Rows[0]["content"].ToString(); if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["progress"].ToString() != "") { model.progress = int.Parse(ds.Tables[0].Rows[0]["progress"].ToString()); } if (ds.Tables[0].Rows[0]["createdon"].ToString() != "") { model.createdon = DateTime.Parse(ds.Tables[0].Rows[0]["createdon"].ToString()); } if (ds.Tables[0].Rows[0]["createdbyid"].ToString() != "") { model.createdbyid = int.Parse(ds.Tables[0].Rows[0]["createdbyid"].ToString()); } model.watchidsoftheday = ds.Tables[0].Rows[0]["watchidsoftheday"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_workorder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_workorder set "); strSql.Append(" viewcount = @viewcount , "); strSql.Append(" latestviewdate = @latestviewdate , "); strSql.Append(" score = @score , "); strSql.Append(" pushedremind = @pushedremind , "); strSql.Append(" pushreminddate = @pushreminddate , "); strSql.Append(" closereason = @closereason , "); strSql.Append(" initiatorreason = @initiatorreason , "); strSql.Append(" handlerreason = @handlerreason , "); strSql.Append(" result = @result , "); strSql.Append(" catalog = @catalog , "); strSql.Append(" title = @title , "); strSql.Append(" content = @content , "); strSql.Append(" status = @status , "); strSql.Append(" progress = @progress , "); strSql.Append(" createdon = @createdon , "); strSql.Append(" createdbyid = @createdbyid , "); strSql.Append(" watchidsoftheday = @watchidsoftheday "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@viewcount", SqlDbType.Int, 4), new SqlParameter("@latestviewdate", SqlDbType.DateTime), new SqlParameter("@score", SqlDbType.Int, 4), new SqlParameter("@pushedremind", SqlDbType.Bit, 1), new SqlParameter("@pushreminddate", SqlDbType.DateTime), new SqlParameter("@closereason", SqlDbType.NVarChar, -1), new SqlParameter("@initiatorreason", SqlDbType.NVarChar, -1), new SqlParameter("@handlerreason", SqlDbType.NVarChar, -1), new SqlParameter("@result", SqlDbType.NVarChar, 255), new SqlParameter("@catalog", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 255), new SqlParameter("@content", SqlDbType.NVarChar, -1), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@progress", SqlDbType.Int, 4), new SqlParameter("@createdon", SqlDbType.DateTime), new SqlParameter("@createdbyid", SqlDbType.Int, 4), new SqlParameter("@watchidsoftheday", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.id; parameters[1].Value = model.viewcount; parameters[2].Value = model.latestviewdate; parameters[3].Value = model.score; parameters[4].Value = model.pushedremind; parameters[5].Value = model.pushreminddate; parameters[6].Value = model.closereason; parameters[7].Value = model.initiatorreason; parameters[8].Value = model.handlerreason; parameters[9].Value = model.result; parameters[10].Value = model.catalog; parameters[11].Value = model.title; parameters[12].Value = model.content; parameters[13].Value = model.status; parameters[14].Value = model.progress; parameters[15].Value = model.createdon; parameters[16].Value = model.createdbyid; parameters[17].Value = model.watchidsoftheday; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }