public void addBTOceanOrder(BTOceanOrder obj)
{
try
{
if (iplr.GetListByPdLineAndModel(obj.pdLine, obj.model).Count <= 0)
{
BTOceanOrder item = new BTOceanOrder();
item.pdLine = obj.pdLine;
item.model = obj.model;
item.editor = obj.editor;
DateTime dnow = DateTime.Now;
item.cdt = dnow;
item.udt = dnow;
iplr.AddBTOceanOrder(item);
}
else
{
//已经存在具有相同pdlien和model的BToceanOrder记录
List<string> erpara = new List<string>();
FisException ex;
ex = new FisException("DMT085", erpara);
throw ex;
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存提交的excel到数据库
/// </summary>
/// <param name="dt"></param>
protected void saveDataTabel(DataTable dt)
{
BTOceanOrder btd = new BTOceanOrder();
btd.pdLine = this.CmPdLine.InnerDropDownList.SelectedValue.ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() != "")
{
btd.model = dt.Rows[i][0].ToString();
btd.editor = this.HiddenUsername.Value;
btd.cdt = DateTime.Now;
btd.udt = DateTime.Now;
IBTOceanOrder.addBTOceanOrder(btd);
}
}
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_ServerClick(Object sender, EventArgs e)
{
BTOceanOrder item = new BTOceanOrder();
string pdLine = this.CmPdLine.InnerDropDownList.SelectedValue.ToString();
string model = this.dModel.Text;
string oldPdLine = this.hidPdLine.Value;
string oldModel = this.hidModel.Value;
try
{
IBTOceanOrder.deleteBTOceanOrderByPdlineAndModel(oldPdLine, oldModel);
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
showErrorMessage(ex.Message);
return;
}
ShowBTOceanOrderList();
this.UpdatePanel2.Update();
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "DeleteComplete();", true);
}
///// <summary>
///// 添加数据方法
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
protected void btnAdd_serverClick(Object sender, EventArgs e)
{
BTOceanOrder item = new BTOceanOrder();
string PdLine = this.CmPdLine.InnerDropDownList.SelectedValue.ToString().Trim();
string Model = this.dModel.Text.ToString().Trim().ToUpper();
item.pdLine = PdLine;
item.model = Model;
item.editor = this.HiddenUsername.Value;
item.cdt = DateTime.Now;
item.udt = DateTime.Now;
try
{
IBTOceanOrder.addBTOceanOrder(item);
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
//show error
showErrorMessage(ex.Message);
return;
}
ShowBTOceanOrderList();
this.UpdatePanel2.Update();
PdLine = replaceSpecialChart(PdLine);
Model = replaceSpecialChart(Model);
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "AddUpdateComplete('" + PdLine + "','" + Model + "');", true);
}
public void UpdateBTOceanOrderbyPdlineAndModelDefered(IUnitOfWork uow, BTOceanOrder obj, string pdLine, string model)
{
InvokeBody.AddOneInvokeBody(this, uow, MethodBase.GetCurrentMethod(), obj, pdLine, model);
}
public void AddBTOceanOrderDefered(IUnitOfWork uow, BTOceanOrder obj)
{
InvokeBody.AddOneInvokeBody(this, uow, MethodBase.GetCurrentMethod(), obj);
}
public void UpdateBTOceanOrderbyPdlineAndModel(BTOceanOrder obj, string pdLine, string model)
{
try
{
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
Bt_Seashipmentsku cond = new Bt_Seashipmentsku();
cond.pdLine = pdLine;
cond.model = model;
Bt_Seashipmentsku setv = FuncNew.SetColumnFromField<Bt_Seashipmentsku, BTOceanOrder>(obj, Bt_Seashipmentsku.fn_id, Bt_Seashipmentsku.fn_cdt);
setv.udt = DateTime.Now;
sqlCtx = FuncNew.GetConditionedUpdate<Bt_Seashipmentsku>(tk, new SetValueCollection<Bt_Seashipmentsku>(new CommonSetValue<Bt_Seashipmentsku>(setv)), new ConditionCollection<Bt_Seashipmentsku>(new EqualCondition<Bt_Seashipmentsku>(cond)));
}
}
sqlCtx.Param(Bt_Seashipmentsku.fn_pdLine).Value = pdLine;
sqlCtx.Param(Bt_Seashipmentsku.fn_model).Value = model;
sqlCtx = FuncNew.SetColumnFromField<Bt_Seashipmentsku, BTOceanOrder>(sqlCtx, obj, true);
DateTime cmDt = _Schema.SqlHelper.GetDateTime();
sqlCtx.Param(g.DecSV(Bt_Seashipmentsku.fn_udt)).Value = cmDt;
_Schema.SqlHelper.ExecuteNonQuery(_Schema.SqlHelper.ConnectionString_PAK, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params);
}
catch (Exception)
{
throw;
}
}
public void AddBTOceanOrder(BTOceanOrder obj)
{
try
{
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
sqlCtx = FuncNew.GetAquireIdInsert<Bt_Seashipmentsku>(tk);
}
}
DateTime cmDt = _Schema.SqlHelper.GetDateTime();
sqlCtx = FuncNew.SetColumnFromField<Bt_Seashipmentsku, BTOceanOrder>(sqlCtx, obj);
sqlCtx.Param(Bt_Seashipmentsku.fn_cdt).Value = cmDt;
sqlCtx.Param(Bt_Seashipmentsku.fn_udt).Value = cmDt;
obj.id = _Schema.SqlHelper.ExecuteScalarForAquireIdInsert(_Schema.SqlHelper.ConnectionString_PAK, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params);
}
catch (Exception)
{
throw;
}
}
public void updateBTOceanOrderbyPdlineAndModel(BTOceanOrder obj, string pdLine, string model)
{
try
{
if (iplr.GetListByPdLineAndModel(obj.pdLine, obj.model).Count <= 0)
{
BTOceanOrder btoor = new BTOceanOrder();
btoor.pdLine = obj.pdLine;
btoor.model = obj.model;
btoor.editor = obj.editor;
btoor.udt = obj.udt;
iplr.UpdateBTOceanOrderbyPdlineAndModel(btoor, pdLine, model);
}
else
{ //已经存在具有相同pdlien和model的BToceanOrder记录
List<string> erpara = new List<string>();
FisException ex;
ex = new FisException("DMT085", erpara);
throw ex;
}
}
catch (FisException e)
{
logger.Error(e.mErrmsg);
throw e;
}
catch (Exception e)
{
logger.Error(e.Message);
throw;
}
}
