/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void OKButton_Click(object sender, EventArgs e)
{
using (ContractProvider contProvider = new ContractProvider())
{
var dateModel = LocalGlobal.GetDateModel();
string aDate = LocalGlobal.ConvertDateFormat(ActualDate.Text.Trim()).ToString("yyyyMMdd");
if (this.CurrentItem.Length == 0)
{
//新增
if (contProvider.GetArprocessDetailItem(this.CurrentID, cboItem.SelectedValue.Trim(), Seq.Text.Trim()) == null) //不存在
{
try
{
contProvider.InsertArprocessDetail(Seq.Text.Trim(), CurrentID, cboItem.SelectedValue.Trim(), SAmt.Text.Trim(), Per.Text.Trim(), aDate, ActualAmt.Text.Trim(), cboType.SelectedValue.Trim(), Remark.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
}
catch (Exception error)
{
this.ShowErrorMessage(this.GetGlobalResourceString("CreateErrorMessage") + error.Message);
return;
}
}
else
{
this.ShowWarningMessage(this.GetGlobalResourceString("ExistedErrorMessage"));
return;
}
}
else
{
//编辑
try
{
contProvider.UpdateArprocessDetail(CurrentID, CurrentItem, CurrentSeq, aDate, ActualAmt.Text.Trim(), cboType.SelectedValue.Trim(), Remark.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
}
catch (Exception error)
{
this.ShowErrorMessage(this.GetGlobalResourceString("UpdateErrorMessage") + error.Message);
return;
}
}
}
//回调
this.DialogCallback("'CloseRefresh'", "window");
}
/// <summary>
/// 保存
/// </summary>
protected void SaveButton_Click(object sender, EventArgs e)
{
#region 检测
int count = 0;
foreach (GridViewRow row in PRList.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
count++;
string prDate = ((TextBox)row.FindControl("PRLPDTE")).Text.Trim();
if (LocalGlobal.ConvertDateFormat(prDate) <= DateTime.Today)
{
this.ShowInfoMessage("日期须在明天以后!");
return;
}
}
}
if (count <= 0)
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
return;
}
#endregion
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
var dateModel = LocalGlobal.GetDateModel();
string prNo = string.Empty;
using (PurProvider purProvider = new PurProvider())
{
try
{
if (PRNo.Text.Trim().Length == 0) //新增
{
prNo = purProvider.GetMaxPRNo().ToString(); //生成新的请购单号
if (DRAWNO.Text.Trim().Length == 0)
{
DRAWNO.Text = " ";
}
}
else
{
//修改请购单
prNo = PRNo.Text.Trim();
//先删除再添加
cmd.CommandText = purProvider.DeletePRSql(prNo);
cmd.ExecuteNonQuery();
cmd.CommandText = purProvider.DeletePRDetailSql(prNo);
cmd.ExecuteNonQuery();
}
#region Insert
cmd.CommandText = purProvider.InsertPRSql(prNo, ORDNO.Text.Trim(), DRAWNO.Text, "F", " ", "委外请购", LocalGlobal.CurrentUserID, dateModel.DateStr, LocalGlobal.CurrentUserID, dateModel.DateStr);
cmd.ExecuteNonQuery();
int seq = 0;
foreach (GridViewRow row in PRList.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
HtmlInputCheckBox urgentCheckControl = (HtmlInputCheckBox)row.FindControl("UrgentCheck");
if (rowCheckControl.Checked)
{
seq++;
string isUrgent = urgentCheckControl.Checked ? "Y" : "N";
string prlstation = ((TextBox)row.FindControl("prlstation")).Text.Trim();
string prQty = ((TextBox)row.FindControl("PRLQTY")).Text.Trim();
string prDate = ((TextBox)row.FindControl("PRLPDTE")).Text.Trim();
prDate = LocalGlobal.ConvertDateFormat(prDate).ToString("yyyyMMdd");
cmd.CommandText = purProvider.InsertPRDetailSql(prNo, seq.ToString(), " ", prQty, prDate, prDate, "GT", ORDNO.Text.Trim(), "", row.Cells[3].Text.Trim(), prlstation, row.Cells[6].Text.Trim(), isUrgent, row.Cells[9].Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr, "委外请购", row.Cells[7].Text.Trim());
cmd.ExecuteNonQuery();
}
}
#endregion
if (PRNo.Text.Trim().Length > 0)
{
//更新状态
cmd.CommandText = purProvider.UpdatePRStatusSql(prNo, "UP");
cmd.ExecuteNonQuery();
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败。" + error.Message);
return;
}
tran.Commit();
PRNo.Text = prNo;
PRStatus.Text = LocalGlobal.GetPRStatus(prNo);
this.BindList();
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
#region 检测
if (PRNo.Text.Trim().Length <= 0)
{
this.ShowWarningMessage("请输入请购单号！");
return;
}
#endregion
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
var dateModel = LocalGlobal.GetDateModel();
using (PurProvider purProvider = new PurProvider())
{
try
{
bool flag = false;
foreach (GridViewRow row in List.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
string seq = row.Cells[2].Text.Trim();
string price = ((TextBox)row.FindControl("prlpacst")).Text.Trim();
string vendorNo = ((TextBox)row.FindControl("prlvnd")).Text.Trim();
string vendorName = ((TextBox)row.FindControl("prlvndm")).Text.Trim();
string curr = ((TextBox)row.FindControl("prlcur")).Text.Trim();
string isWeight = IsWeight.Checked ? "Y" : "";
#region 检测
if (Util.ToDecimal(price) <= 0)
{
tran.Rollback();
this.ShowWarningMessage("请填写单价");
return;
}
if (vendorNo.Length <= 0)
{
tran.Rollback();
this.ShowWarningMessage("请填写厂商代码");
return;
}
if (vendorName.Length <= 0)
{
tran.Rollback();
this.ShowWarningMessage("请填写厂商名称");
return;
}
#endregion
cmd.CommandText = purProvider.UpdatePRDetailSql(PRNo.Text.Trim(), seq.ToString(), price, vendorNo, vendorName, curr, isWeight, dateModel.DateStr);
cmd.ExecuteNonQuery();
flag = true;
}
}
if (flag)
{
//更新状态
cmd.CommandText = purProvider.UpdatePRStatusSql(PRNo.Text.Trim(), "UP");
cmd.ExecuteNonQuery();
}
else
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败。" + error.Message);
return;
}
tran.Commit();
}
this.BindList();
this.PostButton.Enabled = true;
}
/// <summary>
/// 确定
/// </summary>
protected void OKButton_Click(object sender, EventArgs e)
{
var totalPer = Util.ToDecimal(SCH_YF.Text.Trim()) + Util.ToDecimal(SCH_JD.Text.Trim()) + Util.ToDecimal(SCH_TH.Text.Trim()) + Util.ToDecimal(SCH_ZB.Text.Trim());
if (totalPer != 100)
{
this.ShowErrorMessage("比例输入不正确，请确保各项总额为100！");
return;
}
var signDate = LocalGlobal.ConvertDateFormat(SIGNDATE.Text.Trim()).ToString("yyyyMMdd");
var deliverDate = LocalGlobal.ConvertDateFormat(DELIVERYDATE.Text.Trim()).ToString("yyyyMMdd");
var deliverDateS = LocalGlobal.ConvertDateFormat(DELIVERYDATE.Text.Trim()).ToString("yyyy-MM-dd");
var dateModel = LocalGlobal.GetDateModel();
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
try
{
using (ContractProvider contProvider = new ContractProvider())
{
string stno = string.Empty, whCode = string.Empty;
if (CurrentType == "2") //直接开票
{
stno = LocalGlobal.NewSTNo(); //发货单号
var wh = contProvider.GetBaseParam("WH", "1");
if (wh != null && wh.Rows.Count > 0)
{
whCode = wh.Rows[0]["description"].ToString().Trim();
}
}
string orno = string.Empty;
if (this.CurrentID.Length == 0) //新增
{
orno = LocalGlobal.NewOrno(false);
#region 合同、收款进度头表
cmd.CommandText = contProvider.InsertContractSql(orno, ORDNAME.Text.Trim(), CUSTNO.Text.Trim(), CUSTNAME.Text.Trim(), CURR.SelectedValue.Trim(), signDate, deliverDate, PROTECTTERM.SelectedValue.Trim(), SCH_YF.Text.Trim(), SCH_JD.Text.Trim(), SCH_TH.Text.Trim(), SCH_ZB.Text.Trim(), ORDAMT.Text.Trim(), Remark.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.InsertArprocessSql(orno, ORDNAME.Text.Trim(), CUSTNO.Text.Trim(), CUSTNAME.Text.Trim(), CURR.SelectedValue.Trim(), ORDAMT.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
#endregion
#region 收款进度明细
cmd.CommandText = contProvider.InsertArprocessDetailSql(orno, "T1", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_YF.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.InsertArprocessDetailSql(orno, "T2", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_JD.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.InsertArprocessDetailSql(orno, "T3", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_TH.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.InsertArprocessDetailSql(orno, "T4", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_ZB.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.InsertArprocessDetailSql(orno, "T5", Util.ToDecimal(ORDAMT.Text.Trim()), 0, LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
#endregion
}
else //编辑
{
orno = ORDNO.Text.Trim();
#region 合同、收款进度头表
cmd.CommandText = contProvider.UpdateContractSql(orno, ORDNAME.Text.Trim(), CUSTNO.Text.Trim(), CUSTNAME.Text.Trim(), CURR.SelectedValue.Trim(), signDate, deliverDate, PROTECTTERM.SelectedValue.Trim(), SCH_YF.Text.Trim(), SCH_JD.Text.Trim(), SCH_TH.Text.Trim(), SCH_ZB.Text.Trim(), ORDAMT.Text.Trim(), Remark.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.UpdateArprocessSql(orno, ORDNAME.Text.Trim(), CUSTNO.Text.Trim(), CUSTNAME.Text.Trim(), CURR.SelectedValue.Trim(), ORDAMT.Text.Trim(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
#endregion
#region 收款进度明细
cmd.CommandText = contProvider.UpdateArprocessDetailSql(orno, "T1", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_YF.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.UpdateArprocessDetailSql(orno, "T2", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_JD.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.UpdateArprocessDetailSql(orno, "T3", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_TH.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.UpdateArprocessDetailSql(orno, "T4", Util.ToDecimal(ORDAMT.Text.Trim()), Util.ToDecimal(SCH_ZB.Text.Trim()), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
#endregion
}
if (CurrentType == "2") //直接开票
{
cmd.CommandText = contProvider.DeleteKpSql(orno);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.DeleteShipSql(orno);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.DeleteTransDetailSql(orno);
cmd.ExecuteNonQuery();
}
#region 合同明细
cmd.CommandText = contProvider.DeleteContractDetailSql(orno);
cmd.ExecuteNonQuery();
//bool flag = true;
//if (List.Rows.Count == 1) //只有一行数据，判断是否是空行
//{
// var name = ((DataBoundLiteralControl)List.Rows[0].Cells[2].Controls[0]).Text.Trim();
// if (name.Length == 0) //自动创建的空行
// {
// flag = false;
// }
//}
//if (flag)
//{
// for (int i = 0; i < List.Rows.Count; i++)
// {
// var row = List.Rows[i];
// cmd.CommandText = contProvider.InsertContractDetailSql(orno, ((Label)row.FindControl("SEQ")).Text.Trim(), ((DataBoundLiteralControl)row.Cells[2].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[4].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[3].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[5].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[6].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[7].Controls[0]).Text.Trim(), ((DataBoundLiteralControl)row.Cells[8].Controls[0]).Text.Trim());
// cmd.ExecuteNonQuery();
// }
//}
var table = ViewState["ViewDT"] as DataTable;
int seq = 0;
foreach (DataRow row in table.Rows)
{
seq++;
cmd.CommandText = contProvider.InsertContractDetailSql(orno, seq.ToString(), row["ITEMNO"].ToString().Trim(), row["ORDQTY"].ToString(), row["DRAWNO"].ToString(), row["UM"].ToString(), row["UNITPRICE"].ToString(), row["AMT"].ToString(), row["Remark"].ToString());
cmd.ExecuteNonQuery();
#region 直接开票
if (CurrentType == "2") //直接开票
{
//1.扣减库存，写出库记录
cmd.CommandText = contProvider.InsertShipSql(stno, seq.ToString(), orno, row["DRAWNO"].ToString().Trim(), CUSTNO.Text.Trim(), CUSTNAME.Text.Trim(), row["ITEMNO"].ToString(), row["UM"].ToString(), row["ORDQTY"].ToString(), row["ORDQTY"].ToString(), row["ORDQTY"].ToString(), deliverDate, "1");
cmd.ExecuteNonQuery();
var invTable = contProvider.GetInventoryByItem(whCode, row["DRAWNO"].ToString().Trim());
if (invTable != null && invTable.Rows.Count > 0)
{
cmd.CommandText = contProvider.UpdateInventorySql(whCode, row["DRAWNO"].ToString().Trim(), row["ORDQTY"].ToString());
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = contProvider.InsertInventorySql(whCode, row["DRAWNO"].ToString().Trim(), "", "", row["ITEMNO"].ToString(), row["ORDQTY"].ToString(), row["UM"].ToString());
cmd.ExecuteNonQuery();
}
cmd.CommandText = contProvider.InsertTransDetailSql(orno, row["DRAWNO"].ToString().Trim(), whCode, row["ORDQTY"].ToString(), stno, orno.Substring(0, 7), "B");
cmd.ExecuteNonQuery();
//2.开票
cmd.CommandText = contProvider.InsertKpSql(orno, seq.ToString(), "1", FP.Text.Trim(), row["ORDQTY"].ToString(), row["AMT"].ToString(), deliverDateS);
cmd.ExecuteNonQuery();
}
#endregion
}
#endregion
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败！" + error.Message);
return;
}
tran.Commit();
//回调
this.DialogCallback("'CloseRefresh'", "window");
}
/// <summary>
/// 保存
/// </summary>
protected void SaveButton_Click(object sender, EventArgs e)
{
var table = ViewState["ViewDT"] as DataTable;
if (table == null || table.Rows.Count == 0)
{
return;
}
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
var dateModel = LocalGlobal.GetDateModel();
string prNo = string.Empty;
using (PurProvider purProvider = new PurProvider())
{
try
{
if (PRNo.Text.Trim().Length == 0) //新增
{
prNo = purProvider.GetMaxPRNo().ToString(); //生成新的请购单号
cmd.CommandText = purProvider.InsertPRSql(prNo, "", "", "S", "RMB", "材料请购", LocalGlobal.CurrentUserID, dateModel.DateStr, "", "0");
cmd.ExecuteNonQuery();
PRStatus.Text = "NE";
}
else
{
//修改请购单
prNo = PRNo.Text.Trim();
//先删除再添加
cmd.CommandText = purProvider.DeletePRDetailSql(prNo);
cmd.ExecuteNonQuery();
//更新状态
cmd.CommandText = purProvider.UpdatePRStatusSql(prNo, "UP");
cmd.ExecuteNonQuery();
PRStatus.Text = "UP";
}
#region Insert
int seq = 0;
foreach (DataRow row in table.Rows)
{
seq++;
string prDate = row["PRLPDTE"].ToString().Trim();
prDate = LocalGlobal.ConvertDateFormat(prDate).ToString("yyyyMMdd");
cmd.CommandText = purProvider.InsertMatPRDetailSql(prNo, seq.ToString(), row["PRLQTY"].ToString().Trim(), prDate, prlwhs.Text.Trim(), row["prltno"].ToString(), row["prlstation"].ToString(), row["prlrule"].ToString(), row["prlum"].ToString(), LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr, row["prlmrk"].ToString(), row["prloutno"].ToString(), row["prlpicno"].ToString());
cmd.ExecuteNonQuery();
}
#endregion
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败。" + error.Message);
return;
}
tran.Commit();
PRNo.Text = prNo;
this.BindList();
}
}
/// <summary>
/// 删除
/// </summary>
protected void DeleteButton_Click(object sender, EventArgs e)
{
bool deleted = false;
var dateModel = LocalGlobal.GetDateModel();
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
try
{
using (ContractProvider contProvider = new ContractProvider())
{
foreach (GridViewRow row in List.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
string orno = List.DataKeys[row.RowIndex]["ORDNO"].ToString().Trim();
//合同
cmd.CommandText = contProvider.DeleteContractSql(orno);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.DeleteContractDetailSql(orno);
cmd.ExecuteNonQuery();
//收款进度
cmd.CommandText = contProvider.DeleteArprocessSql(orno, LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
cmd.CommandText = contProvider.DeleteArprocessDetailSql(orno, LocalGlobal.CurrentUserID, dateModel.DateStr, dateModel.TimeStr);
cmd.ExecuteNonQuery();
//有项被删除
deleted = true;
}
}
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage(this.GetGlobalResourceString("DeleteErrorMessage") + error.Message);
return;
}
tran.Commit();
if (deleted)
{
this.BindList();
}
else
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
}
}
