protected override void billDelRow()
{
if (string.IsNullOrWhiteSpace(docBILLNO.Text))
{
Alert.Show("空单据，无法进行【删行】操作");
return;
}
if (docFLAG.SelectedValue != "M")
{
Alert.Show("非新单，不能进行【删行】操作！");
return;
}
if (GridLis.SelectedCell == null)
{
return;
}
int rowIndex = GridLis.SelectedRowIndex;
if (rowIndex < 0)
{
return;
}
PageContext.RegisterStartupScript(Confirm.GetShowReference("确认要对第【" + (rowIndex + 1) + "】行进行【删行】的操作吗？", "警告提示",
MessageBoxIcon.Information, PageManager1.GetCustomEventReference("billDelRow_Ok"),
PageManager1.GetCustomEventReference("billDelRow_Cancel"))); //,true
//20150510 liuz
List <Dictionary <string, object> > newDict = GridLis.GetNewAddedList();
newDict.RemoveAt(rowIndex);
}
protected bool DataSave(string flag = "N")
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非[已提交]不能保存！", "消息提示", MessageBoxIcon.Warning);
return(false);
}
List <Dictionary <string, object> > goodsData = GridLis.GetNewAddedList().OrderBy(x => x["GDSEQ"]).ToList();
if (goodsData.Count < 1)
{
Alert.Show("请添加要生成养护单的商品信息！", "提示信息", MessageBoxIcon.Warning);
return(false);
}
List <CommandInfo> cmdList = new List <CommandInfo>();
if (PubFunc.StrIsEmpty(docSEQNO.Text))
{
docSEQNO.Text = BillSeqGet();
docBILLNO.Text = docSEQNO.Text;
}
else
{
if (docBILLNO.Text.Length > 16)
{
Alert.Show("单据编号长度不能大于16，请检查！", "消息提示", MessageBoxIcon.Warning);
return(false);
}
docSEQNO.Text = docBILLNO.Text;
}
cmdList.Add(new CommandInfo("delete from dat_yh_doc where seqno='" + docSEQNO.Text + "'", null));
cmdList.Add(new CommandInfo("delete from dat_yh_com where seqno='" + docSEQNO.Text + "'", null));
MyTable mtType = new MyTable("DAT_YH_DOC");
mtType.ColRow = PubFunc.FormDataHT(Formlis);
mtType.ColRow.Add("BILLTYPE", BillType);
decimal decTotal = 0;
MyTable mtTypeMx = new MyTable("DAT_YH_COM");
//先删除单据信息在插入
for (int i = 0; i < goodsData.Count; i++)
{
mtTypeMx.ColRow = PubFunc.GridDataGet(goodsData[i]);
if (mtTypeMx.ColRow["REASON"].ToString().Length > 80)
{
Alert.Show("第【" + i + 1 + "】行【原因说明】字段超出规定长度");
return(false);
}
mtTypeMx.ColRow.Add("SEQNO", docBILLNO.Text);
mtTypeMx.ColRow["ROWNO"] = i + 1;
mtTypeMx.ColRow.Add("PH", mtTypeMx.ColRow["PHID"]);
decTotal += decimal.Parse(mtTypeMx.ColRow["HSJE"].ToString());
mtTypeMx.ColRow.Remove("UNITNAME");
mtTypeMx.ColRow.Remove("PRODUCERNAME");
cmdList.Add(mtTypeMx.Insert());
}
mtType.ColRow.Add("SUBNUM", goodsData.Count);
mtType.ColRow.Add("SUBSUM", decTotal);
if (flag == "Y")
{
mtType.ColRow["FLAG"] = "Y";
//mtType.ColRow["SHR"] = ddlSHR.SelectedValue;
mtType.ColRow["SHR"] = UserAction.UserID;
mtType.ColRow["SHRQ"] = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now);
}
cmdList.Add(mtType.Insert());
return(DbHelperOra.ExecuteSqlTran(cmdList));
}
