private void ShowDefineInfo()
{
if (DefineCodeDt == null)
{
return;
}
if (DefineCodeDt.DefaultView.Count == 0)
{
return;
}
DataRow dr = this.gVDefineInfo.GetDataRow(this.gVDefineInfo.FocusedRowHandle);
defineInfoModel = GetDefineInfoModel(dr);
//显示数据
if (defineInfoModel != null)
{
this.txtViewProductName.Text = defineInfoModel.CommerceName;
this.txtViewCommName.Text = defineInfoModel.CommonName;
this.txtViewSpec.Text = defineInfoModel.Spec;
this.txtViewModel.Text = defineInfoModel.Model;
this.txtViewManuName.Text = defineInfoModel.ManuName;
this.txtViewPrice.Text = defineInfoModel.Price;
this.txtProductMnemonic.Text = defineInfoModel.ProductMnemonic;
this.txtSelfPackage.Text = defineInfoModel.SelfPackage;
this.txtAlias.Text = defineInfoModel.Alias;
this.txtAliasPinyin.Text = defineInfoModel.AliasPinyin;
}
}
/// <summary>
/// 判断自定义编码产品表中该产品是否已添加
/// </summary>
/// <param name="productcode"></param>
/// <returns></returns>
public bool DefineCodeIsAddProductId(DefineInfoModel model, DbTransaction transaction)
{
bool flag = false;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Select
Count(1)
From hc_self_define_info
Where HIT_COMM_ID='{0}'", model.Hit_Comm_Id);
try
{
int Count = Convert.ToInt16(DbFacade.SQLExecuteScalar(strSql.ToString(), transaction).ToString());
if (Count > 0)
{
//已添加
flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
//获取当前自定义编码修改对象
private DefineInfoModel GetDefineInfoModel()
{
DefineInfoModel model = new DefineInfoModel();
model.Hit_Comm_Id = strHitCommID;
model.ProductMnemonic = this.txtProductMnemonic.Text.Trim();
model.SelfPackage = this.txtSelfPackage.Text.Trim();
model.Alias = this.txtAlias.Text.Trim();
model.AliasPinyin = this.txtAliasPinyin.Text.Trim();
return(model);
}
/// <summary>
/// 获取修改后的自定义编码列表对象
/// </summary>
/// <returns></returns>
private List <DefineInfoModel> GetDefineInfoListModel()
{
defineInfoListModel.Clear();
foreach (DataRow dr in DefineCodeDt.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
//if (!string.IsNullOrEmpty(dr["SELF_PACKAGE"].ToString()))
//{
DefineInfoModel model = GetDefineInfoModel(dr);
defineInfoListModel.Add(model);
//}
}
}
return(defineInfoListModel);
}
/// <summary>
/// 自定义编码及大包装操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void OperatorDefineInfo(DefineInfoModel model, LogedInUser logedinUser, DbTransaction transaction)
{
try
{
//判断该产品ID是否已添加 是则进入修改 否则进入新增方法
if (!DefineCodeIsAddProductId(model, transaction))
{
InsertDefineInfo(model, logedinUser, transaction);
}
else
{
ModifyDefineInfo(model, logedinUser, transaction);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取当前选中行对象
/// </summary>
/// <returns></returns>
private DefineInfoModel GetDefineInfoModel(DataRow dr)
{
DefineInfoModel model = new DefineInfoModel();
model.Hit_Comm_Id = dr["HIT_COMM_ID"].ToString();
model.CommerceName = dr["PRODUCT_NAME"].ToString();
model.CommonName = dr["COMMON_NAME"].ToString();
model.Spec = dr["SPEC"].ToString();
model.Model = dr["MODEL"].ToString();
model.ManuName = dr["MANU_NAME"].ToString();
model.Price = base.SetNumFormat(dr["PRICE"].ToString());
model.ProductMnemonic = dr["PRODUCT_MNEMONIC"].ToString();
model.SelfPackage = dr["SELF_PACKAGE"].ToString();
if (string.IsNullOrEmpty(model.SelfPackage))
{
model.SelfPackage = "1";
}
model.Alias = dr["ALIAS"].ToString();
model.AliasPinyin = dr["ALIAS_PINYIN"].ToString();
return(model);
}
/// <summary>
/// 修改保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.txtProductMnemonic.Text))
{
if (DefineCodeBLL.GetInstance().DefineCodeIsAddProductMnemonic(this.txtProductMnemonic.Text, strHitCommID))
{
XtraMessageBox.Show("自定义编码已存在，请重新输入！", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.txtProductMnemonic.Focus();
return;
}
}
if (this.LueSenderName.EditValue == null)
{
XtraMessageBox.Show("请选择配送商企业！", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
OrdHitCommMode ordHitCommmodel = GetOrdHitCommModel();
List <DefineInfoModel> defineInfoListmodel = new List <DefineInfoModel>();
DefineInfoModel defineInfoModel = GetDefineInfoModel();
defineInfoListmodel.Add(defineInfoModel);
try
{
StockListBLL.GetInstance().PostOrdHitCommInfo(ordHitCommmodel, CurrentUser);
DefineCodeBLL.GetInstance().OperatorDefineInfoList(defineInfoListmodel, CurrentUser);
XtraMessageBox.Show("采购目录信息修改成功！", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.EditFlag = true;
this.Close();
}
catch (Exception ex)
{
XtraMessageBox.Show("采购目录信息修改失败！", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 自定义编码及大包装保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void InsertDefineInfo(DefineInfoModel model, LogedInUser logedinUser, DbTransaction transaction)
{
int result = 0;
//生成本地ID
string strId = base.GetClientId(logedinUser.HighId).ToString();
string strOrgId = logedinUser.UserOrg.Id;
StringBuilder strSql = new StringBuilder();
strSql.Append("Insert Into hc_self_define_info");
strSql.Append(" (");
strSql.Append("ID, ORGID, HIT_COMM_ID, PRODUCT_MNEMONIC, SELF_PACKAGE, ALIAS, ALIAS_PINYIN, MODIFY_USERID, MODIFY_DATE, SYNC_STATE");
strSql.Append(")");
strSql.Append(" Values");
strSql.Append("(");
strSql.AppendFormat("'{0}',", strId);
strSql.AppendFormat("'{0}',", strOrgId);
strSql.AppendFormat("'{0}',", model.Hit_Comm_Id);
strSql.AppendFormat("'{0}',", model.ProductMnemonic);
strSql.AppendFormat("'{0}',", model.SelfPackage);
strSql.AppendFormat("'{0}',", model.Alias);
strSql.AppendFormat("'{0}',", model.AliasPinyin);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
strSql.Append("'0'");
strSql.Append(")");
try
{
result = base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 自定义编码及大包装修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void ModifyDefineInfo(DefineInfoModel model, LogedInUser logedinUser, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update hc_self_define_info ");
strSql.Append("Set ");
strSql.Append(" SYNC_STATE='0'");
strSql.AppendFormat(",PRODUCT_MNEMONIC='{0}'", model.ProductMnemonic);
strSql.AppendFormat(",SELF_PACKAGE='{0}'", model.SelfPackage);
strSql.AppendFormat(",ALIAS='{0}'", model.Alias);
strSql.AppendFormat(",ALIAS_PINYIN='{0}'", model.AliasPinyin);
strSql.AppendFormat(",MODIFY_USERID='{0}'", logedinUser.UserInfo.Id);
strSql.AppendFormat(",MODIFY_DATE='{0}'", DateTime.Now.ToShortDateString());
strSql.AppendFormat(" Where HIT_COMM_ID='{0}'", model.Hit_Comm_Id);
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}