/// <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);
}
}
