private void btnDelete_Click(object sender, EventArgs e)
{
if (gridView1.RowCount > 0)
{
DataRowView dr = (DataRowView)(gridView1.GetFocusedRow());
if (MessageBox.Show("确定删除该数据！", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ChangeBillManage ChangeBillManage = new ChangeBillManage();
dr = (DataRowView)(gridView1.GetFocusedRow());
if (ChangeBillManage.GetIsCheck(dr["ChangeBillGuID"].ToString()) == false)
{
ChangeBillManage.DeleteChangeBill(dr["ChangeBillGuID"].ToString());
//写日志
SysLog.AddOperateLog(SysParams.UserName, "工程更改单删除", "删除", SysParams.UserName + "用户删除了工程更改单,工程更改单唯一号:" + dr["ChangeBillGuID"].ToString());
gridView1.DeleteSelectedRows();
this.ShowMessage("删除成功!");
}
else
{
this.ShowMessage("此单据已经审核,不能删除!");
}
}
}
}
public void LoadData()
{
ChangeBillManage ChangeBillManage = new ChangeBillManage();
DataTable dtl = ChangeBillManage.GetChangeBill(GetWhereSQL());
gridControl1.DataSource = dtl;
}
/// <summary>
/// 加载数据
/// </summary>
/// <param name="MaterialGuid"></param>
private void FillData(string ChangeBillGuID)
{
ChangeBillManage ChangeBillManage = new ChangeBillManage();
DataTable dtl = ChangeBillManage.GetChangeBillByChangeBillGuID(ChangeBillGuID);
if (dtl.Rows.Count > 0)
{
txtGuid.Text = dtl.Rows[0]["ChangeBillGuID"].ToString();
txtChangeBillID.Text = dtl.Rows[0]["ChangeBillID"].ToString();
if (dtl.Rows[0]["ChangeBillDate"].ToString() != "")
{
dtpChangeBillDate.Text = DateTime.Parse(dtl.Rows[0]["ChangeBillDate"].ToString()).ToString("yyyy-MM-dd");
}
txtChangePerson.Text = dtl.Rows[0]["ChangePersonName"].ToString();
txtChangePerson.Tag = dtl.Rows[0]["ChangePerson"].ToString();
txtFileID.Text = dtl.Rows[0]["FileID"].ToString();
txtFileID.Tag = dtl.Rows[0]["FileGuID"].ToString();
txtFileName.Text = dtl.Rows[0]["FileName"].ToString();
txtOldVersionID.Text = dtl.Rows[0]["OldVersionID"].ToString();
txtNewVersionID.Text = dtl.Rows[0]["NewVersionID"].ToString();
txtRemark.Text = dtl.Rows[0]["Remark"].ToString();
txtCreateGuid.Tag = dtl.Rows[0]["CreateGuid"].ToString();
txtCreateGuid.Text = dtl.Rows[0]["CreateName"].ToString();
if (dtl.Rows[0]["CreateDate"].ToString().Contains("1900-01-01") == false)
{
txtCreateDate.Text = dtl.Rows[0]["CreateDate"].ToString();
}
else
{
txtCreateDate.Text = "";
}
txtCheckGuid.Tag = dtl.Rows[0]["CheckGuid"].ToString();
txtCheckGuid.Text = dtl.Rows[0]["CheckName"].ToString();
if (dtl.Rows[0]["CheckDate"].ToString().Contains("1900-01-01") == false)
{
txtCheckDate.Text = dtl.Rows[0]["CheckDate"].ToString();
}
else
{
txtCheckDate.Text = "";
}
//是否一级审核
if (txtCheckGuid.Text.Trim() != "")
{
tsbSave.Enabled = false;
tsbCheck.Enabled = false;
tsbUnCheck.Enabled = true;
}
else
{
tsbSave.Enabled = true;
tsbCheck.Enabled = true;
tsbUnCheck.Enabled = false;
}
}
//加载明细数据
DataTable dtlDetail = ChangeBillManage.GetChangeBillDataAttachment(ChangeBillGuID);
for (int i = 0; i < dtlDetail.Rows.Count; i++)
{
byte[] byteFile = (byte[])dtlDetail.Rows[i]["FileContent"];
ChangeBillDataAttachment ChangeBillDataAttachment = new ChangeBillDataAttachment();
ChangeBillDataAttachment.ChangeBillDataAttachmentGuID = dtlDetail.Rows[i]["ChangeBillDataAttachmentGuID"].ToString();
ChangeBillDataAttachment.ChangeBillGuID = dtlDetail.Rows[i]["ChangeBillGuID"].ToString();
ChangeBillDataAttachment.FileContent = byteFile;
ChangeBillDataAttachment.FileSourceName = dtlDetail.Rows[i]["FileSourceName"].ToString();
lst.Add(ChangeBillDataAttachment);
//文件增加到chklist中
ListItem item = new ListItem();
item.Text = ChangeBillDataAttachment.FileSourceName;
item.Value = ChangeBillDataAttachment.ChangeBillDataAttachmentGuID;
chklstFile.Items.Add(item);
}
}
//保存
private void btnSave_Click(object sender, EventArgs e)
{
if (txtChangeBillID.Text.Trim() == "")
{
this.ShowAlertMessage("请输入工程更改单号!");
txtChangeBillID.Focus();
return;
}
if (txtFileID.Text.Trim() == "")
{
this.ShowAlertMessage("请选择文件!");
txtFileID.Focus();
return;
}
if (dtpChangeBillDate.Text.Trim() == "")
{
this.ShowAlertMessage("请输入开单日期!");
dtpChangeBillDate.Focus();
return;
}
if (txtChangePerson.Text.Trim() == "")
{
this.ShowAlertMessage("请输入更改人!");
txtChangePerson.Focus();
return;
}
if (txtOldVersionID.Text.Trim() == "")
{
this.ShowAlertMessage("请输入旧版本!");
txtOldVersionID.Focus();
return;
}
if (txtNewVersionID.Text.Trim() == "")
{
this.ShowAlertMessage("请输入新版本!");
txtNewVersionID.Focus();
return;
}
ChangeBillManage ChangeBillManage = new ChangeBillManage();
//判断当前工程更改编号是否已经存在相同的,如果已经存在则给出提示
if (ChangeBillManage.IsExistChangeBillID(txtChangeBillID.Text.Replace("'", "''"), txtGuid.Text, IsEdit) == true)
{
this.ShowAlertMessage("你输入的工程更改编号已经存在,请修改后再确定!");
return;
}
ChangeBill ChangeBill = new ChangeBill();
ChangeBill.ChangeBillGuID = txtGuid.Text.Replace("'", "''");
ChangeBill.ChangeBillID = txtChangeBillID.Text.Replace("'", "''");
ChangeBill.ChangeBillDate = DateTime.Parse(dtpChangeBillDate.Text);
ChangeBill.FileGuID = txtFileID.Tag.ToString();
ChangeBill.NewVersionID = txtNewVersionID.Text;
if (txtChangePerson.Tag != null)
{
ChangeBill.ChangePerson = txtChangePerson.Tag.ToString();
}
else
{
ChangeBill.ChangePerson = "";
}
ChangeBill.Remark = txtRemark.Text.Trim().Replace("'", "''");
ChangeBill.CreateGuid = txtCreateGuid.Tag.ToString();
ChangeBill.CreateDate = DateTime.Now;
ChangeBill.CheckGuid = "";
ChangeBill.CheckDate = DateTime.Parse("1900-01-01");
ChangeBill.CheckGuid = "";
//保存
ChangeBillManage.SaveChangeBill(ChangeBill, lst);
//写日志
SysLog.AddOperateLog(SysParams.UserName, "工程更改单数据", "新增或编辑", SysParams.UserName + "用户新增或编辑了工程更改单，工程更改单:" + ChangeBill.ChangeBillGuID + "," + ChangeBill.ChangeBillID + "," + ChangeBill.NewVersionID);
IsEdit = true;
//刷新
frmChangeBill.frmchangeBill.LoadData();
tsbSave.Enabled = true;
tsbCheck.Enabled = true;
tsbUnCheck.Enabled = false;
SetRight();
this.ShowMessage("保存成功!");
}
