/// <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); }