/// <summary>
/// 删除
/// </summary>
protected void DeleteButton_Click(object sender, EventArgs e)
{
using (PurProvider purProvider = new PurProvider())
{
string prNo = PRNo.Text.Trim();
if (prNo.Length <= 0)
{
this.ShowWarningMessage("请输入请购单号");
return;
}
try
{
purProvider.DeleteMatPR(prNo);
//this.ShowMessage("删除成功");
this.BindList();
}
catch (Exception error)
{
this.ShowErrorMessage("删除失败。" + error.Message);
return;
}
}
}
/// <summary>
/// 行绑定
/// </summary>
protected void List_RowDataBound(object sender, GridViewRowEventArgs e)
{
switch (e.Row.RowType)
{
//数据行
case DataControlRowType.DataRow:
#region 数据绑定
string orNo = ((DataRowView)e.Row.DataItem)["ordno"].ToString().Trim();
string seq = ((DataRowView)e.Row.DataItem)["seq"].ToString().Trim();
string ordQty = ((DataRowView)e.Row.DataItem)["ordqty"].ToString().Trim(); //需求数量
using (PurProvider purProvider = new PurProvider())
{
int actualQty = purProvider.GetActualShipQty(orNo, seq); //实际出货数量
string noShipQty = (Util.ToInt(ordQty) - actualQty).ToString(); //未出货数量
e.Row.Cells[6].Text = noShipQty;
}
#endregion
break;
case DataControlRowType.EmptyDataRow:
case DataControlRowType.Header:
case DataControlRowType.Separator:
case DataControlRowType.Pager:
case DataControlRowType.Footer:
default:
break;
}
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
/* 查找可出货工令
* SELECT m.* FROM(
* select b.*,rcnam,(select sum(shipqact) rqty from shiping where shipsono=a.ordno and shipseq=b.seq) rqty
* FROM contract a,contratdetail b,salrcm
* WHERE a.ordno=b.ordno and a.custno=rccust
* )m WHERE m.ordqty-m.rqty>0
*/
using (PurProvider purProvider = new PurProvider())
{
string orNo = ORDNO.Text.Trim();
if (orNo.Length > 0)
{
DataTable table = purProvider.GetShipNoticeList(orNo);
if (table != null && table.Rows.Count > 0)
{
CustNo.Text = table.Rows[0]["custno"].ToString();
CustName.Text = table.Rows[0]["rcnam"].ToString();
RDate.Text = table.Rows[0]["deliverydate"].ToString();
}
List.DataSource = table;
List.DataBind();
}
else
{
Initialize();
List.DataSource = null;
List.DataBind();
}
}
}
/// <summary>
/// 生成新发货单号
/// </summary>
/// <returns></returns>
public static string NewSTNo()
{
var dateModel = GetDateModel();
string no = string.Empty;
using (PurProvider purProvider = new PurProvider())
{
var param = purProvider.GetBaseParam("ST", "NO");
if (param != null && param.Rows.Count > 0)
{
string stno = param.Rows[0]["description"].ToString(); //ST1703997
string year = stno.Substring(2, 2);
string num = stno.Substring(4, 5);
if (dateModel.YearStr == year)
{
no = "ST" + year + (Util.ToInt(num) + 1).ToString().PadLeft(5, '0');
}
else
{
no = "ST" + dateModel.YearStr + (Util.ToInt(num) + 1).ToString().PadLeft(5, '0');
}
}
else
{
no = "ST" + dateModel.YearStr + "00001";
}
purProvider.UpdateBaseParam("ST", "NO", no);
}
return(no);
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
string shipNo = ShipNo.Text.Trim();
if (shipNo.Length > 0)
{
DataTable table = purProvider.GetShipList(shipNo);
if (table != null && table.Rows.Count > 0)
{
ORDNO.Text = table.Rows[0]["shipsono"].ToString();
CustNo.Text = table.Rows[0]["shipcustno"].ToString();
CustName.Text = table.Rows[0]["shipcustname"].ToString();
RDate.Text = table.Rows[0]["deliverydate"].ToString();
}
List.DataSource = table;
List.DataBind();
}
else
{
Initialize();
List.DataSource = null;
List.DataBind();
}
}
}
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
List.DataSource = purProvider.GetCustomerByName(Name.Text.Trim());
}
List.DataBind();
}
/// <summary>
/// 获取工件bom数量
/// </summary>
public static int GetBomQty(string orNo, string bomSeq, string prType)
{
int qty = 0;
using (PurProvider purProvider = new PurProvider())
{
qty = purProvider.GetBOMQty(orNo, bomSeq, prType);
}
return(qty);
}
/// <summary>
/// 获取请购单状态
/// </summary>
public static string GetPRStatus(string prNo)
{
string status = string.Empty;
using (PurProvider purProvider = new PurProvider())
{
status = purProvider.GetPRStatus(prNo);
}
return(status);
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
string dateFrom = LocalGlobal.ConvertDateFormat(DateFrom.Text.Trim()).ToString("yyyyMMdd");
string dateTo = LocalGlobal.ConvertDateFormat(DateTo.Text.Trim()).ToString("yyyyMMdd");
DataTable table = purProvider.ShipQuery(ORDNO.Text.Trim(), CUSTNO.Text.Trim(), dateFrom, dateTo);
List.DataSource = table;
}
List.DataBind();
}
protected void List_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
this.List.SelectedIndex = e.NewSelectedIndex;
string no = this.List.DataKeys[this.List.SelectedIndex]["PRHNO"].ToString();
//绑定详情列表
//DetailLabel.Visible = true;
using (PurProvider purProvider = new PurProvider())
{
DetailList.DataSource = purProvider.GetPRCheckDetail(no);
}
DetailList.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
DataTable table = purProvider.GetPRCheckList();
List.DataSource = table;
}
List.DataBind();
this.List.SelectedIndex = -1;
DetailList.DataSource = null;
DetailList.DataBind();
}
/// <summary>
/// 否决
/// </summary>
protected void RejectButton_Click(object sender, EventArgs e)
{
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
using (PurProvider purProvider = new PurProvider())
{
try
{
bool flag = false;
foreach (GridViewRow row in DetailList.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
string prNo = row.Cells[1].Text.Trim();
string seq = row.Cells[2].Text.Trim();
cmd.CommandText = purProvider.RejectPr(prNo, seq);
cmd.ExecuteNonQuery();
flag = true;
}
}
if (flag)
{
tran.Commit();
this.BindList();
}
else
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("提交失败。" + error.Message);
return;
}
}
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
string prNo = PRNo.Text.Trim();
if (prNo.Length > 0)
{
var pur = purProvider.GetPRDetail(prNo);
if (pur != null)
{
ORDNO.Text = pur["PRHSORD"].ToString();
DRAWNO.Text = pur["PRHMNO"].ToString();
PRType.Text = pur["prhpgm"].ToString();
PRStatus.Text = pur["PRHSTAT"].ToString();
DataTable table;
if (ORDNO.Text.Trim().Length > 0) //非材料请购
{
table = purProvider.GetPRDetailNotMat(prNo);
}
else //材料请购
{
table = purProvider.GetPRDetailMat(prNo);
}
List.DataSource = table;
List.DataBind();
PostButton.Enabled = true;
}
else
{
this.Initialize();
List.DataSource = null;
List.DataBind();
}
}
else
{
this.Initialize();
List.DataSource = null;
List.DataBind();
}
}
}
/// <summary>
/// 初始化
/// </summary>
private void Initialize()
{
string prNo = this.CurrentID;
DataTable table = new DataTable();
using (PurProvider purProvider = new PurProvider())
{
if (CurrentSource == "maintain")
{
var pur = purProvider.GetPRDetail(prNo);
if (pur == null)
{
//this.ShowWarningMessage("请购单号码有误！");
//return;
Response.Write("请购单号码有误！");
Response.End();
return;
}
string prType = pur["prhtyp"].ToString().Trim();
if (string.IsNullOrWhiteSpace(prType))
{
Response.Write("请购单号码有误！");
Response.End();
return;
}
this.PrType = prType;
//请购数据源
table = purProvider.GetPRMainPrint(this.PrType, prNo);
}
else if (CurrentSource == "print")
{
table = purProvider.GetPROrderPrint(this.PrType, this.PrNoFrom, this.PrNoTo, this.VenNo);
}
}
string report = "RLPUR.Web.Pur" + this.PrType + ".rdlc";
Viewer.LocalReport.ReportEmbeddedResource = report;
Viewer.LocalReport.DataSources.Clear();
Viewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", table));
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
if (PRNo.Text.Trim().Length <= 0)
{
DataTable bomTable = purProvider.GetBOMList(ORDNO.Text.Trim(), this.BomType.SelectedValue.Trim());
List.DataSource = bomTable;
List.DataBind();
if (bomTable != null && bomTable.Rows.Count > 0)
{
DRAWNO.Text = bomTable.Rows[0]["bommno"].ToString();
}
ViewState["ViewDT"] = this.CreateTable();
BindTempData();
}
else
{
List.DataSource = null;
List.DataBind();
DataTable prTable = purProvider.GetPRDetailList(PRNo.Text.Trim());
ViewState["ViewDT"] = prTable;
BindTempData();
//PRList.DataSource = prTable;
//PRList.DataBind();
if (prTable != null && prTable.Rows.Count > 0)
{
ORDNO.Text = prTable.Rows[0]["PRHSORD"].ToString();
DRAWNO.Text = prTable.Rows[0]["prhmno"].ToString();
PRStatus.Text = prTable.Rows[0]["PRHSTAT"].ToString();
//默认全部勾选
for (int i = 0; i < PRList.Rows.Count; i++)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)PRList.Rows[i].FindControl("RowCheck");
rowCheckControl.Checked = true;
}
}
}
}
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
string dateFrom = LocalGlobal.ConvertDateFormat(DateFrom.Text.Trim()).ToString("yyyyMMdd");
string dateTo = LocalGlobal.ConvertDateFormat(DateTo.Text.Trim()).ToString("yyyyMMdd");
DataTable table = purProvider.PurQuery(PRNoFrom.Text.Trim(), PRNoTo.Text.Trim(), OrNoFrom.Text.Trim(), OrNoTo.Text.Trim(), VenFrom.Text.Trim(), VenTo.Text.Trim(), dateFrom, dateTo, DrawNoFrom.Text.Trim(), DrawNoTo.Text.Trim(), PrlNo.Text.Trim(), PrlName.Text.Trim());
List.DataSource = table;
decimal amt = 0;
foreach (DataRow row in table.Rows)
{
amt += Util.ToDecimal(row["PRLPACST"].ToString()) * Util.ToDecimal(row["PRLQTY"].ToString());
}
SumAmt.Text = amt.ToString();
}
List.DataBind();
}
/// <summary>
/// 初始化
/// </summary>
private void Initialize()
{
#region 页面内容
using (PurProvider purProvider = new PurProvider())
{
var bomType = purProvider.GetBaseParam("PT", "");
LocalGlobal.BindListItems(BomType, bomType.DefaultView, "Description", "code", true);
}
this.ORDNO.Text = string.Empty;
this.DRAWNO.Text = string.Empty;
this.PRNo.Text = string.Empty;
this.PRStatus.Text = string.Empty;
//this.BomType.SelectedIndex = -1;
#endregion
//绑定列表
//this.BindList();
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindList()
{
using (PurProvider purProvider = new PurProvider())
{
string prNo = PRNo.Text.Trim();
if (prNo.Length > 0)
{
PRStatus.Text = LocalGlobal.GetPRStatus(prNo);
DataTable table = purProvider.GetMatPRDetailList(prNo);
ViewState["ViewDT"] = table;
BindTempData();
}
else
{
this.Initialize();
List.DataSource = null;
List.DataBind();
}
}
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
context.Response.ContentType = "application/json";
using (PurProvider purProvider = new PurProvider())
{
string venNo = context.Request.Form["VendorNo"];
var vendor = purProvider.GetVendor(venNo);
if (vendor == null)
{
context.Response.Write("{\"success\":false,\"message\":\"" + "厂商代码不存在，或者该厂商已失效!" + "\"}");
}
else
{
context.Response.Write("{\"success\":true,\"vendorName\":\"" + vendor["avnam"].ToString() + "\",\"curr\":\"" + vendor["avcur"].ToString() + "\"}");
}
//context.Response.End();
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
#region 检测
if (ORDNO.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;
string shipNo = LocalGlobal.NewSTNo(); //出货单号
using (PurProvider purProvider = new PurProvider())
{
try
{
int seq = 0;
foreach (GridViewRow row in List.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
seq++;
#region 检测
string noShipQty = row.Cells[6].Text.Trim(); //未出货数量
string planQty = ((TextBox)row.FindControl("shipqplan")).Text.Trim(); //计划出货数量
string shipDate = ((TextBox)row.FindControl("shipdate")).Text.Trim(); //出货日期
if (shipDate.Length <= 0)
{
tran.Rollback();
this.ShowWarningMessage("请填写出货日期！");
return;
}
if (Util.ToInt(planQty) <= 0)
{
tran.Rollback();
this.ShowWarningMessage("出货数量必须大于0！");
return;
}
if (Util.ToInt(planQty) > Util.ToInt(noShipQty))
{
tran.Rollback();
this.ShowWarningMessage("出货数量不能大于未出货数量！");
return;
}
string orNo = List.DataKeys[row.RowIndex]["ordno"].ToString().Trim();
var morder = purProvider.GetMOrder(orNo);
if (morder == null || morder.Rows.Count == 0)
{
var beiping = purProvider.GetBeiping(orNo);
if (beiping == null || beiping.Rows.Count == 0)
{
tran.Rollback();
this.ShowWarningMessage("任务的号码有误！");
return;
}
}
#endregion
shipDate = LocalGlobal.ConvertDateFormat(shipDate).ToString("yyyyMMdd");
cmd.CommandText = purProvider.InsertShipSql(shipNo, seq.ToString(), orNo, row.Cells[2].Text.Trim(), CustNo.Text.Trim(), CustName.Text.Trim(), row.Cells[3].Text.Trim(), row.Cells[5].Text.Trim(), row.Cells[4].Text.Trim(), planQty, "0", shipDate, "0");
cmd.ExecuteNonQuery();
}
}
if (seq <= 0)
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败。" + error.Message);
return;
}
tran.Commit();
ShipNo.Text = shipNo;
this.BindList();
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
string shipNo = ShipNo.Text.Trim();
string orNo = ORDNO.Text.Trim();
#region 检测
if (shipNo.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;
using (PurProvider purProvider = new PurProvider())
{
try
{
//仓库
var whs = purProvider.GetBaseParam("WH", "1");
string whsCode = string.Empty;
if (whs != null && whs.Rows.Count > 0)
{
whsCode = whs.Rows[0]["description"].ToString().Trim();
}
bool flag = false;
foreach (GridViewRow row in List.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
string seq = row.Cells[1].Text.Trim();
string drawNo = row.Cells[2].Text.Trim();
string itemName = row.Cells[3].Text.Trim();
string rQty = row.Cells[4].Text.Trim();
string um = row.Cells[5].Text.Trim();
string planQty = row.Cells[6].Text.Trim(); //计划出货数量
string actualQty = ((TextBox)row.FindControl("shipqact")).Text.Trim(); //出货数量
#region 检测
if (actualQty.Length <= 0)
{
tran.Rollback();
this.ShowWarningMessage("请填写出货数量！");
return;
}
if (Util.ToInt(actualQty) <= 0)
{
tran.Rollback();
this.ShowWarningMessage("出货数量必须大于0！");
return;
}
if (Util.ToInt(actualQty) > Util.ToInt(planQty))
{
tran.Rollback();
this.ShowWarningMessage("出货数量不能大于计划出货数量！");
return;
}
#endregion
cmd.CommandText = purProvider.UpdateShipQtySql(shipNo, seq, Util.ToInt(actualQty));
cmd.ExecuteNonQuery();
var invTable = purProvider.GetInventoryByItem(whsCode, drawNo);
if (invTable != null && invTable.Rows.Count > 0)
{
cmd.CommandText = purProvider.UpdateInventorySql(whsCode, drawNo, actualQty);
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = purProvider.InsertInventorySql(whsCode, drawNo, "", "", itemName, actualQty, um);
cmd.ExecuteNonQuery();
}
cmd.CommandText = purProvider.InsertTransDetailSql(orNo, drawNo, whsCode, actualQty, shipNo, orNo.Substring(0, 7), "B");
cmd.ExecuteNonQuery();
cmd.CommandText = purProvider.UpdateShipStatusSql(shipNo, seq);
cmd.ExecuteNonQuery();
decimal zbAmt = 0, limit = 0; //质保金 质保期限
string lastDate = string.Empty; //质保金到期日
var conTable = purProvider.GetContractInfo(orNo, seq);
if (conTable != null && conTable.Rows.Count > 0)
{
decimal unitPrice = Util.ToDecimal(conTable.Rows[0]["unitprice"].ToString());
zbAmt = unitPrice * Util.ToDecimal(actualQty);
limit = Util.ToDecimal(conTable.Rows[0]["protectterm"].ToString());
int diff = Util.ToInt(limit * 12);
lastDate = LocalGlobal.ConvertDateFormat(ShipDate.Text.Trim()).AddMonths(diff).ToString("yyyy-MM-dd");
}
cmd.CommandText = purProvider.InsertZhibaojinSql(shipNo, orNo, seq, itemName, drawNo, CustNo.Text.Trim(), CustName.Text.Trim(), actualQty, zbAmt.ToString(), "0", ShipDate.Text.Trim(), DateTime.Now.ToString("HH:mm:ss"), limit.ToString(), lastDate);
cmd.ExecuteNonQuery();
flag = true;
}
}
if (!flag)
{
this.ShowInfoMessage(this.GetGlobalResourceString("NotSelectMessage"));
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("保存失败。" + error.Message);
return;
}
tran.Commit();
this.ShowInfoMessage("出货成功");
this.Initialize();
this.BindList();
}
}
/// <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();
}
}
/// <summary>
/// 提交
/// </summary>
protected void PostButton_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;
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 status = row.Cells[14].Text.Trim();
if (status == "OK")
{
cmd.CommandText = purProvider.PostPRDetailSql(PRNo.Text.Trim(), seq.ToString());
cmd.ExecuteNonQuery();
flag = true;
}
}
}
if (flag)
{
//更新状态
cmd.CommandText = purProvider.UpdatePRStatusSql(PRNo.Text.Trim(), "PS");
cmd.ExecuteNonQuery();
}
else
{
this.ShowInfoMessage("未选中要提交的记录，请确认请购状态，或未填写价格/厂商！");
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("提交失败。" + error.Message);
return;
}
tran.Commit();
}
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 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();
}
}
