public ActionResult GetWorkCodesDetails(jQueryDataTableParamModel param)
{
IQueryable <WorkCode> tasks = this.db.WorkCodes;
if (tasks != null)
{
List <WorkCodeModel> result = new List <WorkCodeModel>();
foreach (WorkCode task in tasks)
{
WorkCodeModel taskModel = new WorkCodeModel();
taskModel.Id = task.Id;
taskModel.Name = task.Name;
result.Add(taskModel);
}
var resultData = new
{
aaData = result
};
return(Json(resultData, JsonRequestBehavior.AllowGet));
}
else
{
return(new JsonResult());
}
}
/// <summary>
/// 获取记录
/// </summary>
/// <param name="workCode"></param>
/// <returns></returns>
public WorkCodeModel GetByWorkCode(string workCode)
{
string sql = string.Format(@"
select * from WorkCode
where workcode=@workcode
");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@workcode", workCode)
};
DataTable dt = SqliteHelper.GetDataTable(sql, parameters);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
WorkCodeModel model = new WorkCodeModel();
DataRow row = dt.Rows[0];
model.ID = Tools.TryConvertToInt32(row["ID"].ToString());
model.WorkCode = row["workcode"].ToString();
model.WorkName = row["workname"].ToString();
return(model);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_WorkCode.Text))
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "Please select workcode item.";
return;
}
lblMsg.Visible = false;
WorkCodeModel model = _bll.GetByWorkCode(tb_WorkCode.Text.Trim());
if (null == model)
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "The workcode is not exist.";
return;
}
lblMsg.Visible = false;
if (_bll.Delete(tb_WorkCode.Text.Trim()) > 0)
{
LoadAllWorkCode();
this.lblMsg.Visible = true;
this.lblMsg.Text = "Operate successful.";
}
else
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "Operate fail.";
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_WorkCode.Text))
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "Please input workcode.";
return;
}
lblMsg.Visible = false;
WorkCodeModel model = _bll.GetByWorkCode(tb_WorkCode.Text.Trim());
if (model == null)
{
model = new WorkCodeModel();
}
model.WorkCode = tb_WorkCode.Text.Trim();
model.WorkName = tb_WorkName.Text.Trim();
int ret = 0;
try
{
if (model.ID == 0)
{
ret = _bll.Add(model);
if (ret > 0)
{
LoadAllWorkCode();
this.lblMsg.Visible = true;
this.lblMsg.Text = "Add successful.";
}
else
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "Add fail.";
}
}
else
{
ret = _bll.Update(model);
if (ret > 0)
{
LoadAllWorkCode();
this.lblMsg.Visible = true;
this.lblMsg.Text = "Update successful.";
}
else
{
this.lblMsg.Visible = true;
this.lblMsg.Text = "Update fail.";
}
}
}
catch (Exception ex)
{
this.lblMsg.Visible = true;
this.lblMsg.Text = ex.ToString();
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="workCode"></param>
/// <returns></returns>
public int Add(WorkCodeModel workCode)
{
string sql = "insert into WorkCode(workcode,workname) values(@workcode,@workname)";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@workcode", workCode.WorkCode),
new SQLiteParameter("@workname", workCode.WorkName)
};
return(SqliteHelper.ExecuteNonQuery(sql, parameters));
}
public int Update(WorkCodeModel workCode)
{
string sql = string.Format(@"
update WorkCode set
workcode=@workcode
,workname=@workname
where id=@id
");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@id", workCode.ID),
new SQLiteParameter("@workcode", workCode.WorkCode),
new SQLiteParameter("@workname", workCode.WorkName)
};
return(SqliteHelper.ExecuteNonQuery(sql, parameters));
}
/// <summary>
///
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <returns></returns>
public ActionResult AddWorkCode()
{
IQueryable <WorkCode> tasks = this.db.WorkCodes;
WorkCodeModel LastModel = new WorkCodeModel();
if (tasks != null)
{
foreach (WorkCode task in tasks)
{
LastModel.Number = task.Number;
}
}
WorkCode AddWork = new WorkCode();
AddWork.Number = (Convert.ToInt32(LastModel.Number) + 1).ToString();
return(PartialView("_PVAddWorkCodes", AddWork));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workCode"></param>
/// <returns></returns>
public int Update(WorkCodeModel workCode)
{
return(_dal.Update(workCode));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="workCode"></param>
/// <returns></returns>
public int Add(WorkCodeModel workCode)
{
return(_dal.Add(workCode));
}
