/// <summary>
/// 新增按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddNew_Click(object sender, EventArgs e)
{
if (Page.IsValid == false)
{
return;
}
//lblAddMsg.Text = "";
ClearTipMsgLabel();//清除提示信息
try
{
PackageStatistic newModel = null;
string msg = "";
if (GetNewModel(out newModel, out msg) == false)
{
lblAddMsg.Text = msg;
DAL.CommonConvert.ShowMessageBox(this.Page, msg);
return;
}
using (DAL.GoldEntities context = new DAL.GoldEntities())
{
context.PackageStatistic.AddObject(newModel);
context.SaveChanges();
lblAddMsg.Text = "保存成功";
DAL.CommonConvert.ShowMessageBox(this.Page, "保存成功!");
gv_BinList.DataBind();
}
}
catch (Exception ex)
{
DAL.CommonConvert.ShowMessageBox(this.Page, "保存失败!");
lblAddMsg.Text = "保存失败！详细信息：" + Utility.LogHelper.GetExceptionMsg(ex);
}
}
/// <summary>
/// 行命令触发前先清空界面消息提示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gv_BinList_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridView senderGrid = sender as GridView;
//更新或删除前对消息Label清空
if (e.CommandName == "Edit" || e.CommandName == "Update" || e.CommandName == "Delete")
{
//lblGridViewMsg.Text = "";
ClearTipMsgLabel();//清除提示信息
}
else if (e.CommandName == "MyDefineUpdate")
{
lblGridViewMsg.Text = "";
if (senderGrid.EditIndex != -1)
{
int editBinCode = (int)senderGrid.DataKeys[senderGrid.EditIndex].Value;
try
{
using (GoldEntities context = new GoldEntities())
{
PackageStatistic updateModel = (from r in context.PackageStatistic where r.PSID == editBinCode select r).FirstOrDefault();
string msg = "";
if (GetUpdateModel(ref updateModel, senderGrid.Rows[senderGrid.EditIndex], out msg) == false)
{
lblGridViewMsg.Text = msg;
DAL.CommonConvert.ShowMessageBox(this.Page, msg);
return;
}
else
{
int result = context.SaveChanges();
if (result > 0)
{
lblGridViewMsg.Text = "更新成功！";
DAL.CommonConvert.ShowMessageBox(this.Page, "更新成功!");
senderGrid.EditIndex = -1;//取消编辑状态
}
else
{
DAL.CommonConvert.ShowMessageBox(this.Page, "更新失败（影响行数为0）!");
lblGridViewMsg.Text = "更新失败（影响行数为0）";
}
}
}
}
catch (Exception ex)
{
DAL.CommonConvert.ShowMessageBox(this.Page, "更新失败!");
lblGridViewMsg.Text = "更新失败[" + Utility.LogHelper.GetExceptionMsg(ex) + "]";
}
}
}
}
/// <summary>
/// 获取新增界面中的数据
/// </summary>
/// <param name="msg">异常消息</param>
/// <returns></returns>
private bool GetUpdateModel(ref PackageStatistic updateModel, GridViewRow editRow, out string msg)
{
msg = "";
try
{
if (null == editRow)
{
msg = "获取的编辑行为空！请重试！";
return(false);
}
TextBox tbxRowPackageTotalCount = null;
TextBox tbxRowPackageNoStart = null;
TextBox tbxRowPackageNoEnd = null;
TextBox tbxRowComment = null;
tbxRowPackageTotalCount = editRow.FindControl("tbxRowPackageTotalCount") as TextBox;
tbxRowPackageNoStart = editRow.FindControl("tbxRowPackageNoStart") as TextBox;
tbxRowPackageNoEnd = editRow.FindControl("tbxRowPackageNoEnd") as TextBox;
tbxRowComment = editRow.FindControl("tbxRowComment") as TextBox;
if (tbxRowComment == null || tbxRowPackageNoEnd == null || tbxRowPackageNoStart == null || tbxRowPackageTotalCount == null)
{
msg = "未能获取编辑的数据！";
return(false);
}
int packageTotalCount = 0;
if (int.TryParse(tbxRowPackageTotalCount.Text, out packageTotalCount) == false)
{
msg = "总数量只能为数字！";
return(false);
}
updateModel.PackageTotalCount = packageTotalCount;
updateModel.PackageNoStart = tbxRowPackageNoStart.Text.Trim();
updateModel.PackageNoEnd = tbxRowPackageNoEnd.Text.Trim();
updateModel.UpdateTime = DateTime.Now;
updateModel.Remark = tbxRowComment.Text.Trim();
return(true);
}
catch (Exception ex)
{
msg = ex.Message.ToString();
return(false);
}
}
/// <summary>
/// 多项删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
ClearTipMsgLabel();//清除提示信息
List <int> checkedDelList = GetCheckItemID();
if (checkedDelList.Count <= 0)
{
lblCheckMsg.Text = "请先选中待删除的项";
DAL.CommonConvert.ShowMessageBox(this.Page, "请先选中待删除的项!");
return;
}
using (GoldEntities context = new GoldEntities())
{
foreach (int delCode in checkedDelList)
{
PackageStatistic delObject = (from r in context.PackageStatistic where r.PSID.Equals(delCode) select r).FirstOrDefault();
context.DeleteObject(delObject);
}
int delRow = context.SaveChanges();
if (delRow > 0)
{
DAL.CommonConvert.ShowMessageBox(this.Page, "删除成功！[已删除" + delRow.ToString() + "项]");
lblCheckMsg.Text = "删除成功！[已删除" + delRow.ToString() + "项]";
}
else
{
DAL.CommonConvert.ShowMessageBox(this.Page, "删除失败!");
lblCheckMsg.Text = "删除失败！";
}
//GridViewBind();//删除后重新绑定数据
gv_BinList.DataBind();
}
}
catch (Exception ex)
{
DAL.CommonConvert.ShowMessageBox(this.Page, "删除失败!");
lblGridViewMsg.Text = "删除失败[" + Utility.LogHelper.GetExceptionMsg(ex) + "]";
}
}
public void UpdateSupportTypeFor(PackageStatistic stat, SupportType supportType)
{
Updates[stat.Name] = supportType;
}
/// <summary>
/// 获取新增界面中的数据
/// </summary>
/// <param name="msg">异常消息</param>
/// <returns></returns>
private bool GetNewModel(out PackageStatistic newModel, out string msg)
{
msg = "";
newModel = null;
try
{
if (string.IsNullOrEmpty(DropDownListNewWHCode.SelectedItem.Value) ||
string.IsNullOrEmpty(DropDownListNewPackage.SelectedItem.Value) ||
string.IsNullOrEmpty(tbxNewPackageTotalCount.Text.Trim()))
{
msg = "仓库、包装、总数量 均为必填项！请填写！";
return(false);
}
int tempTotalCount = 0;
if (int.TryParse(tbxNewPackageTotalCount.Text, out tempTotalCount) == false)
{
msg = "总数量必须为数字！请重新填写！";
return(false);
}
string whCode = "";
string packageName = "";
newModel = new PackageStatistic();
newModel.WHCode = DropDownListNewWHCode.SelectedItem.Value;
newModel.WHName = DropDownListNewWHCode.SelectedItem.Text;
newModel.PackageName = DropDownListNewPackage.SelectedItem.Text;
int tempPackageID = 0;
if (int.TryParse(DropDownListNewPackage.SelectedItem.Value, out tempPackageID) == true)
{
newModel.PackageId = tempPackageID;
}
else
{
newModel.PackageId = null;
}
newModel.PackageNoStart = tbxNewPackageStart.Text.Trim();
newModel.PackageNoEnd = tbxNewPackageEnd.Text.Trim();
newModel.PackageTotalCount = tempTotalCount;
newModel.Remark = tbxNewRemark.Text;
newModel.UpdateTime = DateTime.Now;
whCode = newModel.WHCode;
packageName = newModel.PackageName.Trim();
using (GoldEntities context = new GoldEntities())
{
var sameCode = (from r in context.PackageStatistic where (r.WHCode == whCode && r.PackageName.Trim() == packageName.Trim()) select r).ToList();
if (sameCode != null && sameCode.Count > 0)
{
msg += "系统中已经存在仓库为[" + whCode + "]、包装为[" + packageName + "]的记录,请重填或编辑现有记录!";
}
if (msg.Length > 0)
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
msg = Utility.LogHelper.GetExceptionMsg(ex);
return(false);
}
}
