void IBLL.ICusFY.Add(Model.rp_t_supcust_fy_master ord, List <Model.rp_t_supcust_fy_detail> lines, out string sheet_no)
{
var db = new DB.DBByHandClose(Appsetting.conn);
DB.IDB d = db;
try
{
db.Open();
db.BeginTran();
//
IBLL.ICusFY bll = this;
sheet_no = ord.sheet_no = bll.MaxCode();
string sql = "select * from rp_t_supcust_fy_master where sheet_no='" + ord.sheet_no + "'";
//
var tb = d.ExecuteToTable(sql, null);
if (tb.Rows.Count != 0)
{
throw new Exception("已存在单号" + ord.sheet_no);
}
d.Insert(ord);
foreach (Model.rp_t_supcust_fy_detail line in lines)
{
sql = "select isnull(max(flow_id)+1,1) from rp_t_supcust_fy_detail";
line.flow_id = Helper.Conv.ToInt64(d.ExecuteScalar(sql, null));
line.sheet_no = sheet_no;
d.Insert(line);
}
//
db.CommitTran();
}
catch (Exception ex)
{
db.RollBackTran();
throw;
}
finally
{
db.Close();
}
}
