private void button2_Click(object sender, EventArgs e)
{
vw_admi611 masterModel = null;
vw_admi611s detailModel = null;
int maxNo = 0;
DataRow drAdmi611s;
try
{
if (Admi611sList.Count == 0)
{
maxNo = 1;
}
else
{
maxNo = Admi611sList.Max(x => x.ady02);
if (GlobalFn.isNullRet(maxNo, 0) == 0)
{
maxNo = 1;
}
else
{
maxNo += 1;
}
}
masterModel = DrMaster.ToItem <vw_admi611>();
detailModel = new vw_admi611s();
detailModel.ady01 = masterModel.adx01;
detailModel.ady02 = maxNo;
detailModel.ady03 = "";
detailModel.ady04 = 0;
detailModel.ady05 = 0;
detailModel.ady06 = 100;
detailModel.ady07 = 20;
var result = WfOpenAdmi611s(YREditType.新增, detailModel, out drAdmi611s);
if (result == DialogResult.Yes)
{
WfIniUcPanel(drAdmi611s.ToItem <vw_admi611s>());
Admi611sList.Add(drAdmi611s.ToItem <vw_admi611s>());
//WfIniUcPanel(detailModel);
//Admi611sList.Add(detailModel);
}
}
catch (Exception ex)
{
WfShowErrorMsg(ex.Message);
}
}
protected override bool WfAppendUpdate()
{
vw_admi611 admi611Model = null;
int chkCnts = 0;
StringBuilder sbSql = null;
List <SqlParameter> sqlParmsList;
CommonBLL boAppend;
DataTable dtady = null;
try
{
boAppend = new InvBLL(BoMaster.OfGetConntion());
boAppend.TRAN = BoMaster.TRAN;
boAppend.OfCreateDao("ady_tb", "*", "");
admi611Model = DrMaster.ToItem <vw_admi611>();
//處理明細--均先刪後新增
if (FormEditMode != YREditType.新增)
{
sbSql = new StringBuilder();
sqlParmsList = new List <SqlParameter>();
sbSql.AppendLine("DELETE FROM ady_tb WHERE ady01=@ady01");
sqlParmsList.Add(new SqlParameter("@ady01", admi611Model.adx01));
chkCnts = boAppend.OfExecuteNonquery(sbSql.ToString(), sqlParmsList.ToArray());
sbSql = new StringBuilder();
sqlParmsList = new List <SqlParameter>();
sbSql.AppendLine("SELECT * FROM ady_tb");
sbSql.AppendLine("WHERE 1<>1");
dtady = boAppend.OfGetDataTable(sbSql.ToString());
foreach (vw_admi611s detailModel in Admi611sList)
{
var drady = dtady.NewRow();
drady["ady01"] = detailModel.ady01;
drady["ady02"] = detailModel.ady02;
drady["ady03"] = detailModel.ady03;
drady["ady04"] = detailModel.ady04;
drady["ady05"] = detailModel.ady05;
drady["ady06"] = detailModel.ady06;
drady["ady07"] = detailModel.ady07;
drady["adycreu"] = detailModel.adycreu;
drady["adycreg"] = detailModel.adycreg;
if (detailModel.adycred == null)
{
drady["adycred"] = DBNull.Value;
}
else
{
drady["adycred"] = detailModel.adycred;
}
drady["adymodu"] = detailModel.adymodu;
drady["adymodg"] = detailModel.adymodg;
if (detailModel.adymodd == null)
{
drady["adymodd"] = DBNull.Value;
}
else
{
drady["adymodd"] = detailModel.adymodd;
}
dtady.Rows.Add(drady);
}
boAppend.OfUpdate(dtady);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
