/// <summary>
/// 判断该项目中产品分类是否 允许订单流程
/// </summary>
/// <param name="model"></param>
/// <param name="logedinUser"></param>
/// <returns></returns>
public bool IsOrdFlagByProductIDAndSalerID(OrdHitCommMode model, DbTransaction transaction)
{
bool flag = false;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Select
COUNT(1)
From HC_PROJECT_PROD_CLASS_CONTENT ppcc,HC_PROJECT_PROD_CLASS_CONFIG pcc
Where ppcc.CLASS_ID=pcc.CLASS_ID And pcc.ORDER_FLAG='1'
And ppcc.PRODUCT_ID='{0}' And pcc.SALER_ID='{1}'", model.Project_Product_Id, model.Saler_Id);
try
{
int Count = Convert.ToInt16(DbFacade.SQLExecuteScalar(strSql.ToString(), transaction).ToString());
if (Count > 0)
{
//允许订单流程
flag = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
/// <summary>
/// 保存采购目录信息（库房、配送商）
/// </summary>
/// <param name="model"></param>
public void PostOrdHitCommInfo(OrdHitCommMode model, LogedInUser logedinUser)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Update
HC_ORD_HIT_COMM
Set STORE_ROOM_ID={0},
STORE_ROOM_NAME='{1}',
SENDER_ID={2},
SENDER_NAME='{3}',
MODIFY_USER_ID={4},
MODIFY_USER_NAME='{5}',
MODIFY_DATE='{6}'
Where ID={7}",
model.Store_Room_Id,
model.StoreRoomName,
model.Sender_Id,
model.SenderName,
logedinUser.UserInfo.Id,
logedinUser.UserInfo.Name,
DateTime.Now.ToString(),
model.Id
);
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 采购目录信息对象
/// </summary>
/// <param name="reader">The reader.</param>
/// <param name="row">The row number.</param>
/// <returns></returns>
private object HitCommModel(IDataReader reader, int row)
{
OrdHitCommMode model = new OrdHitCommMode();
model.Project_Id = Convert.ToString(reader["PROJECT_ID"]);
model.Id = Convert.ToString(reader["ID"]);
model.Project_Product_Id = Convert.ToString(reader["PROJECT_PROD_ID"]);
model.Product_Name = Convert.ToString(reader["PRODUCT_NAME"]);
model.Class_Name = "";//Convert.ToString(reader["Class_Name"]);
model.Spec = Convert.ToString(reader["SPEC"]);
model.Model = Convert.ToString(reader["MODEL"]);
model.Sender_Id = Convert.ToString(reader["SENDER_ID"]);
model.SenderName = Convert.ToString(reader["SENDER_NAME"]);
model.Measure = Convert.ToString(reader["DEFAULT_MEASURE"]);
model.DefaultMeasureEx = Convert.ToString(reader["DEFAULT_MEASURE_EX"]);
model.Store_Room_Id = Convert.ToString(reader["STORE_ROOM_ID"]);
model.StoreRoomName = Convert.ToString(reader["STORE_ROOM_NAME"]);
model.Price = Convert.ToString(reader["PRICE"]);
model.SalerName = Convert.ToString(reader["SALER_NAME"]);
model.ManuName = Convert.ToString(reader["MANU_NAME"]);
model.RegNo = Convert.ToString(reader["REG_NO"]);
model.RegValidDate = Convert.ToString(reader["REG_VALID_DATE"]);
model.Class_Name = Convert.ToString(reader["CLASS_NAME"]);
model.ProductMnemonic = Convert.ToString(reader["PRODUCT_MNEMONIC"]);
model.SelfPackage = Convert.ToString(reader["SELF_PACKAGE"]);
model.Alias = Convert.ToString(reader["ALIAS"]);
model.AliasPinyin = Convert.ToString(reader["ALIAS_PINYIN"]);
return(model);
}
/// <summary>
/// 判断该项目中产品是否已添加到常用采购目录中
/// </summary>
/// <param name="model"></param>
/// <param name="logedinUser"></param>
/// <returns></returns>
public bool OrdHitCommIsAdd(OrdHitCommMode model, DbTransaction transaction)
{
bool flag = false;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Select
Count(1)
From HC_ORD_HIT_COMM
Where PROJECT_PROD_ID='{0}' And SPEC_ID='{1}' And MODEL_ID='{2}'", model.Project_Product_Id, model.Spec_Id, model.Model_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 void AddHitComm()
{
//当采购供应目录不存在该产品时，作新增操作
List <OrdHitCommMode> ListOrdHitCommModel = new List <OrdHitCommMode>();
DataTable Dt = NoSend_OrdInvoiceFromItemDt.DefaultView.ToTable();
foreach (DataRow dr in Dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
//当该产品不在采购目录表中存在 作增加操作
if (string.IsNullOrEmpty(dr["ordHitCommId"].ToString()))
{
OrdHitCommMode model = GetOrdHitCommModel(dr);
ListOrdHitCommModel.Add(model);
}
}
}
//当采购供应目录不存在该产品时，作新增操作
if (ListOrdHitCommModel.Count > 0)
{
StockListBLL.GetInstance().SaveOrdHitCommListModel(ListOrdHitCommModel, this.CurrentUser);
}
}
/// <summary>
/// 初始化查看数据
/// </summary>
/// <param name="model"></param>
private void IniData(OrdHitCommMode model)
{
this.Lbl_Product_Name.Text = model.Product_Name;
this.Lbl_Class_Name.Text = model.Class_Name;
this.Lbl_Spec.Text = model.Spec;
this.Lbl_Model.Text = model.Model;
//this.txt_SenderName.Text = model.SenderName;
this.LueSenderName.EditValue = Convert.ToInt64(model.Sender_Id);
this.Lbl_Measure.Text = model.Measure;
this.Lbl_DefaultMeasureEx.Text = model.DefaultMeasureEx.ToString();
//this.txt_StoreRoomName.Text = model.StoreRoomName;
this.LueStoreName.EditValue = Convert.ToInt64(model.Store_Room_Id);
this.Lbl_Price.Text = base.SetNumFormat(model.Price) + "元";
this.Lbl_SalerName.Text = model.SalerName;
this.Lbl_ManuName.Text = model.ManuName;
this.Lbl_RegNo.Text = model.RegNo;
this.Lbl_Class_Name.Text = model.Class_Name;
if (!string.IsNullOrEmpty(model.RegValidDate))
{
this.Lbl_RegValidDate.Text = Convert.ToDateTime(model.RegValidDate).ToShortDateString();
}
//修改自定义编码信息
this.txtProductMnemonic.Text = model.ProductMnemonic;
this.txtSelfPackage.Text = model.SelfPackage;
if (string.IsNullOrEmpty(this.txtSelfPackage.Text))
{
this.txtSelfPackage.Text = "1";
}
this.txtAlias.Text = model.Alias;
this.txtAliasPinyin.Text = model.AliasPinyin;
}
/// <summary>
/// 获取当前采购供应目录对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private OrdHitCommMode GetOrdHitCommModel(DataRow dr)
{
OrdHitCommMode model = new OrdHitCommMode();
model.Project_Id = dr["PROJECT_ID"].ToString();
model.Project_Product_Id = dr["PROJECT_PRODUCT_ID"].ToString();
model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString();
model.Cont_Product_Id = dr["CONT_PRODUCT_ID"].ToString();
model.Spec_Id = dr["SPEC_ID"].ToString();
model.Model_Id = dr["MODEL_ID"].ToString();
model.Spec = dr["SPEC"].ToString();
model.Model = dr["MODEL"].ToString();
model.Measure = dr["BASE_MEASURE"].ToString();
model.ManuName = dr["MANU_NAME"].ToString();
model.SalerName = dr["SALER_NAME"].ToString();
model.Commerce_Name = dr["COMMERCE_NAME"].ToString();
model.Common_Name = dr["COMMON_NAME"].ToString();
model.Product_Name = dr["PRODUCT_NAME"].ToString();
model.Abbr_py = dr["ABBR_PY"].ToString();
model.Abbr_wb = dr["ABBR_WB"].ToString();
model.Brand = dr["BRAND"].ToString();
model.Price = dr["PRICE"].ToString();
model.Code = dr["PRODUCT_CODE"].ToString();
model.GoodsNo = dr["GOODS_NO"].ToString();
model.Barcode = dr["BARCODE"].ToString();
model.Base_Measure_Spec = dr["BASE_MEASURE_SPEC"].ToString();
model.Base_Measure_Mater = dr["BASE_MEASURE_MATER"].ToString();
model.Max_Price = dr["MAX_PRICE"].ToString();
model.Manu_Id = dr["MANU_ID"].ToString();
model.Saler_Id = dr["SALER_ID"].ToString();
model.Sender_Id = dr["SENDER_ID"].ToString();
model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString();
model.Batch_No = dr["BATCH_NO"].ToString();
model.State = "1";
if (!dr["PBNO"].ToString().Equals("-"))
{
model.Pbno = dr["PBNO"].ToString();
}
model.Send_Batch_No = dr["SEND_BATCH_NO"].ToString();
model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString();
model.ManuNameAbbr = dr["MANU_NAME_ABBR"].ToString();
model.Buyer_Id = dr["BUYER_ID"].ToString();
model.SalerNameAbbr = dr["SALER_NAME_ABBR"].ToString();
model.Measure = dr["DEFAULT_MEASURE"].ToString();
model.DefaultMeasureEx = dr["DEFAULT_MEASURE_EX"].ToString();
model.Instru_Code = dr["INSTRU_CODE"].ToString();
model.Instru_Name = dr["INSTRU_NAME"].ToString();
//产品注册信息
model.RegNo = dr["REG_NO"].ToString();
model.RegValidDate = dr["REG_VALID_DATE"].ToString();
//库房ID
model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString();
model.StoreRoomName = dr["STORE_ROOM_NAME"].ToString();
return(model);
}
/// <summary>
/// 保存采购目录信息（库房、配送商）
/// </summary>
/// <param name="model"></param>
public void PostOrdHitCommInfo(OrdHitCommMode model, LogedInUser logedinUser)
{
try
{
dao.PostOrdHitCommInfo(model, logedinUser);
}
catch (Exception ex)
{
throw ex;
}
}
//获取当前采购目录修改对象
private OrdHitCommMode GetOrdHitCommModel()
{
OrdHitCommMode model = new OrdHitCommMode();
model.Id = strHitCommID;
model.Store_Room_Id = this.LueStoreName.EditValue.ToString();
model.StoreRoomName = this.LueStoreName.Text.ToString();
model.Sender_Id = this.LueSenderName.EditValue.ToString();
model.SenderName = this.LueSenderName.Text.ToString();
return(model);
}
/// <summary>
/// 自定义编码及大包装保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void InsertDefineInfo(OrdHitCommMode model, LogedInUser logedinUser, DbTransaction transaction)
{
int result = 0;
//生成本地ID
string strId = base.GetClientId(logedinUser.HighId).ToString();
string strOrgId = logedinUser.UserOrg.Id;
//大包装默认为1
if (string.IsNullOrEmpty(model.SelfPackage))
{
model.SelfPackage = "1";
}
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.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());
strSql.Append("'0'");
strSql.Append(")");
try
{
result = base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <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="HitCommID"></param>
/// <returns></returns>
public OrdHitCommMode GetOrdHitCommModel(string HitCommID)
{
List <DbParameter> parameters = new List <DbParameter>();
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Select Ohc.*,
Sdi.PRODUCT_MNEMONIC,
Sdi.SELF_PACKAGE,Sdi.ALIAS,Sdi.ALIAS_PINYIN From
(Select
h.PROJECT_ID,
h.ID,
p.PROJECT_TYPE,
(case p.PROJECT_TYPE when '1' then '招投标' when '2' then '备案采购' when '3' then '竞价采购' when '4' then '浏览采购' end) As PROJECT_TYPE_Name,
h.PROJECT_PROD_ID,
h.COMMERCE_NAME,
h.COMMON_NAME,
h.PRODUCT_NAME,
h.SPEC,
h.MODEL,
h.BRAND,
h.DEFAULT_MEASURE,
h.DEFAULT_MEASURE_EX,
h.PRICE,
h.MANU_NAME,
h.SALER_NAME,
org1.ID As SENDER_ID,
org1.ORG_NAME As SENDER_NAME,
h.STORE_ROOM_ID,
h.STORE_ROOM_NAME,
h.REG_NO,
h.REG_VALID_DATE,
ppc.CLASS_NAME
From HC_ORD_HIT_COMM h,HC_ORD_PROJECT p,HC_ORG org1,
HC_PROJECT_PROD_CLASS_CONTENT ppcc,HC_PROJECT_PRODUCT_CLASS ppc
Where h.PROJECT_ID= p.ID And org1.ID=h.SENDER_ID And h.ID=@HitCommID And ppcc.CLASS_ID=ppc.ID
And h.PROJECT_PROD_ID=ppcc.PRODUCT_ID
) As Ohc
Left Join hc_self_define_info sdi on Ohc.ID=sdi.HIT_COMM_ID");
if (!string.IsNullOrEmpty(HitCommID))
{
DbParameter strHitCommID = DbFacade.CreateParameter();
strHitCommID.ParameterName = "HitCommID";
strHitCommID.DbType = DbType.String;
strHitCommID.Value = HitCommID;
parameters.Add(strHitCommID);
}
else
{
return(null);
}
OrdHitCommMode model = null;
try
{
model = base.DbFacade.SQLExecuteObject(strSql.ToString(), new MapRow(HitCommModel), parameters.ToArray()) as OrdHitCommMode;
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
/// <summary>
/// 保存采购目录对象
/// </summary>
/// <param name="HitCommID"></param>
/// <returns></returns>
public void SaveOrdHitCommModel(OrdHitCommMode model, LogedInUser logedinUser, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into HC_ORD_HIT_COMM(
ID,
PROJECT_ID,
PROJECT_PROD_ID,
DATA_PRODUCT_ID,
SPEC_ID,
MODEL_ID,
SPEC,
MODEL,
BASE_MEASURE,
MANU_NAME,
SALER_NAME,
COMMERCE_NAME,
COMMON_NAME,
PRODUCT_NAME,
ABBR_PY,
ABBR_WB,
BRAND,
PRICE,
CODE,
GOODS_NO,
BARCODE,
BASE_MEASURE_SPEC,
BASE_MEASURE_MATER,
MAX_PRICE,
MANU_ID,
SALER_ID,
SENDER_ID,
SENDER_NAME,
SENDER_NAME_ABBR,
STORE_ROOM_ID,
STORE_ROOM_NAME,
MANU_NAME_ABBR,
Buyer_Id,
SALER_NAME_ABBR,
DEFAULT_MEASURE,
DEFAULT_MEASURE_EX,
STATE,
INSTRU_CODE,
INSTRU_NAME,
CREATE_USER_ID,
CREATE_USER_NAME,
CREATE_DATE,
MODIFY_USER_ID,
MODIFY_USER_NAME,
MODIFY_DATE,
REG_NO,
REG_VALID_DATE,
SYNC_STATE
)");
strSql.Append(" Values (");
strSql.AppendFormat("{0},", model.Id);
strSql.AppendFormat("{0},", model.Project_Id);
strSql.AppendFormat("{0},", model.Project_Product_Id);
strSql.AppendFormat("{0},", model.Data_Product_Id);
strSql.AppendFormat("'{0}',", model.Spec_Id);
strSql.AppendFormat("'{0}',", model.Model_Id);
strSql.AppendFormat("'{0}',", model.Spec);
strSql.AppendFormat("'{0}',", model.Model);
strSql.AppendFormat("'{0}',", model.Measure);
strSql.AppendFormat("'{0}',", model.ManuName);
strSql.AppendFormat("'{0}',", model.SalerName);
strSql.AppendFormat("'{0}',", model.Commerce_Name);
strSql.AppendFormat("'{0}',", model.Common_Name);
strSql.AppendFormat("'{0}',", model.Product_Name);
strSql.AppendFormat("'{0}',", model.Abbr_py);
strSql.AppendFormat("'{0}',", model.Abbr_wb);
strSql.AppendFormat("'{0}',", model.Brand);
strSql.AppendFormat("'{0}',", model.Price);
strSql.AppendFormat("'{0}',", model.Code);
strSql.AppendFormat("'{0}',", model.GoodsNo);
strSql.AppendFormat("'{0}',", model.Barcode);
strSql.AppendFormat("'{0}',", model.Base_Measure_Spec);
strSql.AppendFormat("'{0}',", model.Base_Measure_Mater);
strSql.AppendFormat("'{0}',", model.Max_Price);
strSql.AppendFormat("'{0}',", model.Manu_Id);
strSql.AppendFormat("'{0}',", model.Saler_Id);
strSql.AppendFormat("'{0}',", model.Sender_Id);
strSql.AppendFormat("'{0}',", model.SenderName);
strSql.AppendFormat("'{0}',", model.SenderNameAbbr);
strSql.AppendFormat("'{0}',", model.Store_Room_Id);
strSql.AppendFormat("'{0}',", model.StoreRoomName);
strSql.AppendFormat("'{0}',", model.ManuNameAbbr);
strSql.AppendFormat("'{0}',", logedinUser.UserOrg.Id);
strSql.AppendFormat("'{0}',", model.SalerNameAbbr);
strSql.AppendFormat("'{0}',", model.Measure);
strSql.AppendFormat("{0},", model.DefaultMeasureEx);
strSql.Append("'1',");
strSql.AppendFormat("'{0}',", model.Instru_Code);
strSql.AppendFormat("'{0}',", model.Instru_Name);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name);
strSql.AppendFormat("'{0}',", DateTime.Now.ToString());
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name);
strSql.AppendFormat("'{0}',", DateTime.Now.ToString());
strSql.AppendFormat("'{0}',", model.RegNo);
strSql.AppendFormat("'{0}',", model.RegValidDate);
strSql.Append("'0'");
strSql.Append(")");
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
public ViewStockListForm(string HitCommID)
{
InitializeComponent();
strHitCommID = HitCommID;
ordHitCommModel = StockListBLL.GetInstance().GetOrdHitCommModel(HitCommID);
}
