private void DataInit()
{
// 新增数据初始值
JObject defaultObj = new JObject();
defaultObj.Add("GDSEQ", "");
defaultObj.Add("BARCODE", "");
defaultObj.Add("NAME", "");
defaultObj.Add("GDSPEC", "");
defaultObj.Add("UNIT", "");
defaultObj.Add("BZHL", "");
defaultObj.Add("DHSL", "");
defaultObj.Add("XSSL", "");
defaultObj.Add("JXTAX", "");
defaultObj.Add("HSJJ", "");
defaultObj.Add("HSJE", "");
defaultObj.Add("ZPBH", "");
defaultObj.Add("CDID", "");
defaultObj.Add("HWID", "");
defaultObj.Add("PH", "");
defaultObj.Add("PZWH", "");
defaultObj.Add("RQ_SC", "");
defaultObj.Add("YXQZ", "");
defaultObj.Add("MEMO", "");
// 第一行新增一条数据
btnAddRow.OnClientClick = GridGoods.GetAddNewRecordReference(defaultObj, AppendToEnd);
docXSRQ.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
protected void btnClosePostBack_Click(object sender, EventArgs e)
{
bool firstRow = true;
foreach (GridRow row in GridLot.Rows)
{
int rowIndex = row.RowIndex;
System.Web.UI.WebControls.TextBox tbxNumber = (System.Web.UI.WebControls.TextBox)GridLot.Rows[rowIndex].FindControl("tbxNumber");
if (!string.IsNullOrWhiteSpace(tbxNumber.Text) && tbxNumber.Text != "0")
{
string[] strCell = GridGoods.SelectedCell;
JObject defaultObj = Doc.GetJObject(GridGoods, strCell[0]);
defaultObj["PH"] = row.Values[2].ToString();
defaultObj["YXQZ"] = row.Values[3].ToString();
defaultObj["PZWH"] = row.Values[5].ToString();
defaultObj["RQ_SC"] = row.Values[4].ToString();
defaultObj["BZSL"] = tbxNumber.Text;
defaultObj["HWID"] = row.Values[8].ToString();
if (firstRow)
{
firstRow = false;
PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], defaultObj));
}
else
{
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj));
}
}
}
WindowLot.Hidden = true;
}
protected void btnClosePostBack_Click(object sender, EventArgs e)
{
bool firstRow = true;
foreach (GridRow row in GridLot.Rows)
{
int rowIndex = row.RowIndex;
System.Web.UI.WebControls.TextBox tbxNumber = (System.Web.UI.WebControls.TextBox)GridLot.Rows[rowIndex].FindControl("tbxNumber");
if (!string.IsNullOrWhiteSpace(tbxNumber.Text) && tbxNumber.Text != "0")
{
string[] strCell = GridGoods.SelectedCell;
Dictionary <string, object> newDict = GridGoods.GetNewAddedList()[Convert.ToInt32(strCell[0])];
newDict["PH"] = row.Values[1];
newDict["YXQZ"] = row.Values[2];
newDict["PZWH"] = row.Values[4];
newDict["RQ_SC"] = row.Values[3];
newDict["BZSL"] = tbxNumber.Text;
if (firstRow)
{
firstRow = false;
PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], strCell[1], GetJObject(newDict).ToString()));
}
else
{
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(GetJObject(newDict)));
}
}
}
WindowLot.Hidden = true;
}
protected void btnScanClose_Click(object sender, EventArgs e)
{
string seq = GridSacn.Rows[0].Values[1].ToString(), oneCode = "";
foreach (GridRow row in GridSacn.Rows)
{
int rowIndex = row.RowIndex;
System.Web.UI.WebControls.TextBox tbxONECODE = (System.Web.UI.WebControls.TextBox)GridSacn.Rows[rowIndex].FindControl("tbxONECODE");
if (string.IsNullOrWhiteSpace(tbxONECODE.Text))
{
Alert.Show(string.Format("第【{0}】行商品【{1}】唯一码为空！", rowIndex + 1, GridSacn.Rows[rowIndex].Values[1]), "消息提示", MessageBoxIcon.Warning);
return;
}
//验证追溯码是否重复
string tbx = tbxONECODE.Text;
foreach (GridRow rowchild in GridSacn.Rows)
{
int rowIndex_child = rowchild.RowIndex;
System.Web.UI.WebControls.TextBox tbxONECODE_child = (System.Web.UI.WebControls.TextBox)GridSacn.Rows[rowIndex_child].FindControl("tbxONECODE");
string tbx_child = tbxONECODE_child.Text;
if (tbx == tbx_child && rowIndex != rowIndex_child)
{
Alert.Show(string.Format("第【{0}】行与第【{1}】行编码出现重复", rowIndex + 1, rowIndex_child + 1));
return;
}
}
if (DbHelperOra.Exists("select 1 from DAT_CK_EXT where ONECODE = '" + tbxONECODE.Text + "'"))
{
Alert.Show(string.Format("第【{0}】行商品【{1}】唯一码已存在!", rowIndex + 1, GridSacn.Rows[rowIndex].Values[1]), "消息提示", MessageBoxIcon.Warning);
return;
}
if (seq != GridSacn.Rows[rowIndex].Values[1].ToString() || (rowIndex + 1) == GridSacn.Rows.Count)
{
int rowNo = 0;
List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList();
if ((rowIndex + 1) == GridSacn.Rows.Count || GridSacn.Rows.Count == 1)
{
oneCode += tbxONECODE.Text + ",";
}
foreach (Dictionary <string, object> dic in newDict)
{
if (seq == dic["GDSEQ"].ToString())
{
dic["CODEINFO"] = oneCode.TrimEnd(',');
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(GetJObject(dic), rowNo)); oneCode = "";
break;
}
rowNo++;
}
seq = GridSacn.Rows[rowIndex].Values[1].ToString();
}
else
{
oneCode += tbxONECODE.Text + ",";
}
}
WindowScan.Hidden = true;
}
/// <summary>
/// FineUIPro.Grid控件数据加载
/// </summary>
/// <param name="row">要加载的行数据</param>
/// <param name="firstRow">是否插入指定行</param>
/// <param name="flag">数据来源：NEW-从数据库中获得，用于商品新增时；OLD-从销售单据明细中获得，用于修改或审核时</param>
private void LoadGridRow(DataRow row, bool firstRow = true, string flag = "NEW")
{
decimal price = 0, number = 0;
decimal.TryParse(row["HSJJ"].ToString(), out price);
decimal.TryParse(row["BZHL"].ToString(), out number);
row["HSJE"] = (price * number).ToString();
JObject defaultObj = new JObject();
defaultObj.Add("GDSEQ", row["GDSEQ"].ToString());
defaultObj.Add("BARCODE", row["BARCODE"].ToString());
defaultObj.Add("GDNAME", row["GDNAME"].ToString());
defaultObj.Add("GDSPEC", row["GDSPEC"].ToString());
defaultObj.Add("UNIT", row["UNIT"].ToString());
defaultObj.Add("UNITNAME", row["UNITNAME"].ToString());
defaultObj.Add("BZSL", row["BZSL"].ToString());
defaultObj.Add("CH", row["CH"].ToString());
defaultObj.Add("BZHL", row["BZHL"].ToString());
defaultObj.Add("DHSL", "1");
defaultObj.Add("JXTAX", row["JXTAX"].ToString());
defaultObj.Add("HSJJ", row["HSJJ"].ToString());
defaultObj.Add("HSJE", row["HSJE"].ToString());
defaultObj.Add("CHJE", row["CHJE"].ToString());
defaultObj.Add("ZPBH", row["ZPBH"].ToString());
defaultObj.Add("PRODUCER", row["PRODUCER"].ToString());
defaultObj.Add("PRODUCERNAME", row["PRODUCERNAME"].ToString());
defaultObj.Add("HWID", row["HWID"].ToString());
defaultObj.Add("PH", row["PH"].ToString());
defaultObj.Add("PZWH", row["PZWH"].ToString());
defaultObj.Add("RQ_SC", row["RQ_SC"].ToString());
defaultObj.Add("YXQZ", row["YXQZ"].ToString());
defaultObj.Add("MEMO", row["MEMO"].ToString());
defaultObj.Add("ISLOT", row["ISLOT"].ToString());
if (flag == "DSC")
{
defaultObj.Add("STR2", row["STR2"].ToString());
}
if (firstRow)
{
int rowIndex = GridGoods.SelectedRowIndex;
string deleteScript = GridGoods.GetDeleteRowReference(rowIndex);
PageContext.RegisterStartupScript(deleteScript + GridGoods.GetAddNewRecordReference(defaultObj, rowIndex));
}
else
{
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, true));
}
}
protected void Window1_Close(object sender, WindowCloseEventArgs e)
{
bool firstRow = true;
string deleteScript = GridGoods.GetDeleteSelectedReference();
string strValue = hfdValue.Text;
string[] goodsRows = strValue.Split(';');
foreach (string rowValue in goodsRows)
{
string[] goods = rowValue.Split('_');
JObject defaultObj = new JObject();
defaultObj.Add("GDSEQ", goods[0]);
defaultObj.Add("BARCODE", "");
defaultObj.Add("NAME", goods[1]);
defaultObj.Add("GDSPEC", goods[2]);
defaultObj.Add("UNIT", goods[3]);
defaultObj.Add("BZHL", goods[0]);
defaultObj.Add("DHSL", "");
defaultObj.Add("XSSL", "");
defaultObj.Add("JXTAX", "");
defaultObj.Add("HSJJ", "");
defaultObj.Add("HSJE", "");
defaultObj.Add("ZPBH", "");
defaultObj.Add("CDID", "");
defaultObj.Add("HWID", "");
defaultObj.Add("PH", "");
defaultObj.Add("PZWH", "");
defaultObj.Add("RQ_SC", "");
defaultObj.Add("YXQZ", "");
defaultObj.Add("MEMO", "");
if (firstRow)
{
PageContext.RegisterStartupScript(deleteScript + GridGoods.GetAddNewRecordReference(defaultObj, AppendToEnd));
}
else
{
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, AppendToEnd));
}
firstRow = false;
}
}
protected void btnClosePostBack_Click(object sender, EventArgs e)
{
bool firstRow = true;
foreach (GridRow row in GridLot.Rows)
{
int rowIndex = row.RowIndex;
System.Web.UI.WebControls.TextBox tbxNumber = (System.Web.UI.WebControls.TextBox)GridLot.Rows[rowIndex].FindControl("tbxNumber");
if (!string.IsNullOrWhiteSpace(tbxNumber.Text) && tbxNumber.Text != "0")
{
if (!PubFunc.isNumeric(tbxNumber.Text))
{
Alert.Show("请输入正确的数字信息!", "操作提示", MessageBoxIcon.Warning);
return;
}
string[] strCell = GridGoods.SelectedCell;
JObject defaultObj = Doc.GetJObject(GridGoods, strCell[0]);
defaultObj["KCSL"] = row.Values[6].ToString();
defaultObj["PH"] = row.Values[3].ToString();
defaultObj["YXQZ"] = row.Values[4].ToString();
defaultObj["PZWH"] = row.Values[9].ToString();
defaultObj["RQ_SC"] = row.Values[5].ToString();
defaultObj["BZSL"] = Math.Abs(Convert.ToDecimal(tbxNumber.Text));
defaultObj["HWID"] = row.Values[10].ToString();
defaultObj["HSJE"] = (Convert.ToInt16(tbxNumber.Text ?? "0") * Convert.ToDecimal(row.Values[11])).ToString();
if (firstRow)
{
firstRow = false;
PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], defaultObj));
}
else
{
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj));
}
}
}
WindowLot.Hidden = true;
}
protected override void billAddRow()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
string strBillno = docSEQNO.Text;
// 新增数据初始值
JObject defaultObj = new JObject();
defaultObj.Add("GDSEQ", "");
defaultObj.Add("BARCODE", "");
defaultObj.Add("GDNAME", "");
defaultObj.Add("GDSPEC", "");
defaultObj.Add("UNIT", "");
defaultObj.Add("UNITNAME", "");
defaultObj.Add("BZHL", "");
defaultObj.Add("BZSL", "");
defaultObj.Add("DHSL", "");
defaultObj.Add("XSSL", "");
defaultObj.Add("JXTAX", "");
defaultObj.Add("HSJJ", "");
defaultObj.Add("HSJE", "");
defaultObj.Add("ZPBH", "");
defaultObj.Add("PRODUCER", "");
defaultObj.Add("PRODUCERNAME", "");
defaultObj.Add("HWID", "");
defaultObj.Add("PH", "");
defaultObj.Add("PZWH", "");
defaultObj.Add("RQ_SC", "");
defaultObj.Add("YXQZ", "");
defaultObj.Add("MEMO", "");
PubFunc.FormLock(FormDoc, true, "");
trbEditorGDSEQ.Enabled = true;
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, true));
}
protected void Window1_Close(object sender, WindowCloseEventArgs e)
{
DataTable dt = GetGoods(hfdValue.Text);
dt.Columns.Remove(dt.Columns["BZHL"]);
dt.Columns.Remove(dt.Columns["UNIT"]);
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns["UNITNAME"].ColumnName = "UNITSMALLNAME";
dt.Columns["BZHL_SELL"].ColumnName = "BZHL";
dt.Columns["UNIT_SELL_NAME"].ColumnName = "UNITNAME";
dt.Columns["UNIT_SELL"].ColumnName = "UNIT";
dt.Columns.Add("PH", Type.GetType("System.String"));
dt.Columns.Add("RQ_SC", Type.GetType("System.String"));
dt.Columns.Add("YXQZ", Type.GetType("System.String"));
dt.Columns.Add("MEMO", Type.GetType("System.String"));
dt.Columns.Add("BZSL", Type.GetType("System.Int32"));
dt.Columns.Add("DHS", Type.GetType("System.Int32"));
dt.Columns.Add("DHSL", Type.GetType("System.Int32"));
dt.Columns.Add("HSJE", Type.GetType("System.Double"));
dt.Columns.Add("SPZTSL", Type.GetType("System.Int32"));
dt.Columns.Add("KCSL", Type.GetType("System.Double"));
foreach (DataRow row in dt.Rows)
{
row["BZSL"] = "0";
row["DHSL"] = "0";
row["HSJE"] = "0";
//处理金额格式
decimal jingdu = 0;
decimal bzhl = 0;
if (decimal.TryParse(row["HSJJ"].ToString(), out jingdu) && decimal.TryParse(row["BZHL"].ToString(), out bzhl))
{
row["HSJJ"] = Math.Round(jingdu * bzhl, 4).ToString("F4");
}
if (decimal.TryParse(row["YBJ"].ToString(), out jingdu))
{
row["YBJ"] = jingdu.ToString("F4");
}
if (decimal.TryParse(row["HSJE"].ToString(), out jingdu))
{
row["HSJE"] = Math.Round(jingdu, 2).ToString("F2");
}
JObject defaultObj = new JObject();
foreach (DataColumn col in row.Table.Columns)
{
if (col.ColumnName.ToUpper() == "RQ_SC" || col.ColumnName.ToUpper() == "YXQZ")
{
if (!PubFunc.StrIsEmpty(row[col.ColumnName].ToString()))
{
defaultObj.Add(col.ColumnName.ToUpper(), DateTime.Parse(row[col.ColumnName].ToString()));
}
}
else
{
defaultObj.Add(col.ColumnName.ToUpper(), row[col.ColumnName].ToString());
}
}
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, true));
}
}
else
{
Alert.Show("系统传值错误！！！", "消息提示", MessageBoxIcon.Warning);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataInit();
billNew();
//屏蔽不需要的操作按钮
if (Request.QueryString["oper"] != null)
{
string oper = Request.QueryString["oper"].ToString();
hfdOper.Text = oper;
if (oper == "sq")
{
ButtonHidden(btnSaveFa, btnAudit, btnTJFA, btnCancel, btnDelete, btnPrint, btnExport, btnCopy);
TabStrip1.ActiveTabIndex = 1;
strFlagSql += @"SELECT 'M' CODE ,'新单' NAME FROM dual
union all
SELECT 'N' CODE ,'需求提交' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审批' NAME FROM dual
union all
SELECT 'F' CODE ,'已废弃' NAME FROM DUAL ";
PubFunc.DdlDataSql(lstFLAG, strFlagSql);
}
else if (oper == "fa")
{
ButtonHidden(btnNew, btnDel, btnSave, btnTJ, btnAudit, btnAddRow, btnCancel, btnDelRow, btnExport, btnCopy);
btnPrint.Hidden = false;
TabStrip1.ActiveTabIndex = 0;
ddlSPR.SelectedValue = UserAction.UserID;
dpkSPRQ.SelectedDate = DateTime.Now;
billSearch();
strFlagSql += @"SELECT 'N' CODE ,'需求提交' NAME FROM dual
union all
SELECT 'S' CODE ,'方案提交' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审批' NAME FROM dual
union all
SELECT 'R' CODE ,'已驳回' NAME FROM DUAL
union all
SELECT 'F' CODE ,'已废弃' NAME FROM DUAL ";
PubFunc.DdlDataSql(lstFLAG, strFlagSql);
}
else if (oper == "sp")
{
ButtonHidden(btnCancel, btnNew, btnDel, btnSave, btnSaveFa, btnTJ, btnTJFA, btnAddRow, btnDelRow, btnDelete, btnPrint, btnExport, btnCopy);
TabStrip1.ActiveTabIndex = 0;
ddlSHR.SelectedValue = UserAction.UserID;
dpkSHRQ.SelectedDate = DateTime.Now;
billSearch();
strFlagSql += @"SELECT 'S' CODE ,'方案提交' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审批' NAME FROM dual
union all
SELECT 'R' CODE ,'已驳回' NAME FROM DUAL ";
PubFunc.DdlDataSql(lstFLAG, strFlagSql);
}
}
JObject defaultObj = new JObject();
defaultObj.Add("GDNAME", "");
defaultObj.Add("GDSPEC", "");
defaultObj.Add("UNIT", "");
defaultObj.Add("SL", "0");
defaultObj.Add("HSJJ", "");
defaultObj.Add("HSJE", "");
defaultObj.Add("PRODUCER", "");
defaultObj.Add("MEMOGOODS", "");
defaultObj.Add("ISNEW", "");
defaultObj.Add("MEMOBUY", "");
defaultObj.Add("ISPASS", "");
defaultObj.Add("MEMOPASS", "");
// 第一行新增一条数据
btnAddRow.OnClientClick = GridGoods.GetAddNewRecordReference(defaultObj);
}
}
