/// <summary> /// 订单主表更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckRequest(string requestID, out string strInvalid) { strInvalid = ""; bool flag = false; string sql = "select REQUEST_STATE from GPO_REQUEST where ID = :ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "ID"; para.DbType = DbType.AnsiString; para.Value = requestID; Object o = DbFacade.SQLExecuteScalar(sql, para); //判断 ord_order表订单状态 ORDER_STATE 为 3(完成)则不能修改 if (o != null) { string state = o.ToString(); if (state.Equals("8")) { strInvalid = "table:GPO_REQUEST/ID:" + requestID + "/采购申请状态字段为8(作废),不能修改"; flag = false; } else { flag = true; } } return(flag); }
/// <summary> /// 判断该明细所有记录是否已确认 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsAffirmInvoiceFromItemState(string StrInvoiceFromId, DbTransaction transaction) { bool flag = false; StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"Select Count(1) From HC_ORD_INVOICE_FROM_ITEM Where INVOICE_FROM_ID={0} And State='1'", StrInvoiceFromId); try { int Count = Convert.ToInt16(DbFacade.SQLExecuteScalar(strSql.ToString(), transaction).ToString()); if (Count > 0) { //已添加 flag = true; } } catch (Exception ex) { throw ex; } return(flag); }
//检查是否插入采购单记录 public bool CheckPurchaseForInsert(DataRow dr, out string strInvalid) { bool flag = true; string sql = "select state from hc_ord_purchase where id=:id"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "id"; para.DbType = DbType.UInt64; para.Value = dr["id"]; object o = DbFacade.SQLExecuteScalar(sql, para); strInvalid = ""; if (o != null) { //获取状态标记 string state = o.ToString(); if (state.Equals("4")) { strInvalid = "table:hc_ord_purchase/id:" + dr["id"] + "/状态字段为4(发送),不能进行新增操作"; flag = false; } //if (state.Equals("2")) //{ // strInvalid = "table:hc_ord_purchase/id:" + dr["id"] + "/状态字段为2(送审),不能进行新增操作"; // flag = false; //} } return(flag); }
//检查是否可删除采购单明细记录 public bool CheckPurchaseItemForDelete(DataRow dr, out string strInvalid) { bool flag = true; string sql = "select state from hc_ord_purchase hop, hc_ord_purchase_item hopi where hop.id = hopi.PURCHASE_ID and hopi.id=:ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "ID"; para.DbType = DbType.UInt64; para.Value = dr["ID"]; object o = DbFacade.SQLExecuteScalar(sql, para); strInvalid = ""; if (o != null) { string state = o.ToString(); //if (state.Equals("2")) //{ // strInvalid = "table:hc_ord_purchase/id:" + dr["PURCHASE_ID"] + "/采购单主表状态字段为2(送审),不能进行删除操作"; // flag = false; //} if (state.Equals("4")) { strInvalid = "table:hc_ord_purchase/id:" + dr["PURCHASE_ID"] + "/采购单主表状态字段为4(发送),不能进行删除操作"; flag = false; } } return(flag); }
public bool CheckCorpForInsert(DataRow dr, DbTransaction tran, out string strInvalid) { strInvalid = ""; bool flag = false; string sql = "select count(*) from gpo_corp_map g where g.map_orgid = :map_orgid and g.code = :code"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "map_orgid"; para.DbType = DbType.AnsiString; para.Value = dr["map_orgid"].ToString(); DbParameter para1 = this.DbFacade.CreateParameter(); para1.ParameterName = "code"; para1.DbType = DbType.AnsiString; para1.Value = dr["code"].ToString(); Object o = DbFacade.SQLExecuteScalar(sql, tran, para, para1); if (o != null && !o.ToString().Equals("0")) { strInvalid = "table:gpo_corp_map/ID:" + dr["ID"].ToString() + "/机构编码:" + dr["code"].ToString() + "已存在不能新增"; flag = false; } else { flag = true; } return(flag); }
/// <summary> /// 去用户数量 /// </summary> /// <returns></returns> public int GetUserCount(string userCode) { int count; object obj = null; StringBuilder sql = new StringBuilder(); sql.Append("SELECT count(*) FROM cen_usr_user where mail = '"); sql.Append(userCode).Append("' "); try { obj = DbFacade.SQLExecuteScalar(sql.ToString()); } catch (Exception ex) { throw ex; } if (obj != null) { count = (int)obj; } else { count = 0; } return(count); }
/// <summary> /// 订单退货表数据更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckOrderReturnForUpdate(DataRow dr, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select return_state from Gpo_Order_Return where id = :id"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "id"; para.DbType = DbType.AnsiString; para.Value = dr["id"]; Object o = DbFacade.SQLExecuteScalar(sql, para); if (o != null) { string state = o.ToString(); //判断 退货明细表ord_order_return中RETURN_STATE(退货状态)为3 (同意)时,不能进行修改 if (state.Equals("3")) { strInvalid = "table:Ord_Order_Return/id:" + dr["id"] + "/状态字段为3(同意),不能修改"; flag = false; } } return(flag); }
/// <summary> /// 订单到货表数据更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckOrderReceiveForUpdate(DataRow dr, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select state from HC_ORD_ORDER_ITEM where ID = :RECORD_ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "RECORD_ID"; para.DbType = DbType.UInt64; para.Value = dr["ORDER_ITEM_ID"]; Object o = DbFacade.SQLExecuteScalar(sql, para); if (o != null) { string state = o.ToString(); //1、判断订单明细标记状态字段为3(作废)或者5(完成),不能修改 if (state.Equals("3") || state.Equals("5")) { strInvalid = "table:HC_ORD_ORDER_ITEM/ID:" + dr["ORDER_ITEM_ID"] + "/状态字段为3(作废)或5(完成),不能更新订单到货表数据!"; flag = false; } } return(flag); }
/// <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); }
/// <summary> /// 订单主表更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckOrderForUpdate(DataRow dr, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select state from hc_ord_Order where id = :order_id"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "order_id"; para.DbType = DbType.UInt64; para.Value = dr["ID"]; Object o = DbFacade.SQLExecuteScalar(sql, para); //判断 ord_order表订单状态 ORDER_STATE 为 5(完成)6(作废)则不能修改 if (o != null) { string state = o.ToString(); if (state.Equals("5") || state.Equals("6")) { strInvalid = "table:hc_ord_Order/id:" + dr["id"] + "/订单状态字段为5(完成)或6(作废),不能修改"; flag = false; } } return(flag); }
/// <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="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); }
/// <summary> /// 判断备货单明细中是否都已确认 /// </summary> /// <param name="strStockUpID"></param> /// <returns></returns> public bool IsAllAffirmByItem(string strStockUpID, DbTransaction transaction) { bool flag = false; StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"Select Count(1) From HC_ORD_ORD_STOCK_ITEM Where STATE Not In('2','4') And STOCK_ID={0}", strStockUpID); 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="erpHisCode"></param> /// <param name="orgId"></param> /// <returns></returns> public string GetCorpMapData(string erpHisCode, string orgId, out object crpnum) { StringBuilder sb = new StringBuilder(); sb.Append("select org_id from gpo_corp_map p "); sb.AppendFormat(" where p.map_orgid ='{0}'", orgId); sb.AppendFormat(" and p.code ='{0}'", erpHisCode); string result = null; try { object o = DbFacade.SQLExecuteScalar(sb.ToString()); if (o != null) { result = o.ToString(); } } catch (Exception e) { //throw e; } StringBuilder sbNum = new StringBuilder(); sbNum.Append("select count(1) from gpo_corp_map p"); sbNum.AppendFormat(" where p.map_orgid ='{0}'", orgId); sbNum.AppendFormat(" and p.code ='{0}'", erpHisCode); crpnum = DbFacade.SQLExecuteScalar(sbNum.ToString()); return(result); }
/// <summary> /// 判断自定义编码表中 编码是否已存在 /// </summary> /// <param name="strProductMnemonic"></param> /// <param name="strHit_Comm_Id"></param> /// <returns></returns> public bool DefineCodeIsAddProductMnemonic(string strProductMnemonic, string strHit_Comm_Id) { bool flag = false; StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"Select Count(1) From hc_self_define_info Where PRODUCT_MNEMONIC='{0}'", strProductMnemonic); if (!string.IsNullOrEmpty(strHit_Comm_Id)) { strSql.AppendFormat(" And HIT_COMM_ID<>'{0}'", strHit_Comm_Id); } try { int Count = Convert.ToInt16(DbFacade.SQLExecuteScalar(strSql.ToString()).ToString()); if (Count > 0) { //已添加 flag = true; } } catch (Exception ex) { throw ex; } return(flag); }
/// <summary> /// 获取指定序列的ID /// </summary> /// <param name="type">序列前缀</param> /// <param name="seq">序列名</param> /// <returns></returns> protected String GetNewId(String type, string seq) { string sql = "SELECT :TYPE||LPAD(" + seq + ".NEXTVAL, 20, '0') AS ID FROM DUAL "; DbParameter paramType = DbFacade.CreateParameter(); paramType.ParameterName = "TYPE"; paramType.DbType = DbType.String; paramType.Value = type; return(DbFacade.SQLExecuteScalar(sql, paramType).ToString()); }
private string GetOrderCode(DbTransaction tran) { string text1 = "select iif( max(mid(order_code,11,15)) is null, '', max(mid(order_code,11,15)) + 1 ) from gpo_order where order_code like 'CK%'"; string text2 = DbFacade.SQLExecuteScalar(text1, tran).ToString(); if ((text2 != null) && (text2 != "")) { return(int.Parse(text2).ToString("000000000000000")); } return("000000000000001"); }
/// <summary> /// 订单到货表数据插入校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckOrderReceiveForInsert(DataRow dr, DbTransaction trans, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select state from HC_ORD_ORDER_ITEM where ID = :RECORD_ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "RECORD_ID"; para.DbType = DbType.AnsiString; para.Value = dr["ORDER_ITEM_ID"]; Object o = DbFacade.SQLExecuteScalar(sql, para); if (o != null) { string state = o.ToString(); //1、判断订单明细标记状态字段为3(作废)或者5(完成),不能新增 if (state.Equals("5") || state.Equals("3")) { strInvalid = "table:HC_ORD_ORDER_ITEM/ID:" + dr["ORDER_ITEM_ID"] + "/状态字段为3(作废)或5(完成),不能插入订单到货表数据!"; flag = false; } //2、GPO_ORDER_ITEM中订单明细状态ITEM_STATUS 为 7(完成) ,则不能新增 //else if (state.Equals("7")) //{ // //修改原因:离线状态下,产生的GPO_ORDER_ITEM中订单明细状态ITEM_STATUS 为 7(完成)时,上传到服务器上的数据也为 7,导致不能插入订单到货表。 // //修改方法:增加一个判断,检查服务器上有没有对应的到货记录,如果没有则上传到货数据 // //修改时间:2007-05-22 10:08 // //修改人: shejg // if (CheckOrderReceiveForUpdate(dr, out strInvalid)) // { // flag = true; // } // else // { // strInvalid = "table:GPO_ORDER_ITEM/RECORD_ID:" + dr["ORDER_ITEM_ID"] + "/状态字段为7(完成),不能新增"; // flag = false; // } // //strInvalid = "table:GPO_ORDER_ITEM/RECORD_ID:" + dr["ORDER_ITEM_ID"] + "/状态字段为7(缺货),不能新增"; // //flag = false; //} //else //{ // flag = true; //} } return(flag); }
/// <summary> /// 取得系统当前时间 /// </summary> /// <returns></returns> public string GetSysDate() { string syncTime; try { syncTime = DbFacade.SQLExecuteScalar("select sysdate from dual").ToString(); } catch (Exception e) { throw e; } return(syncTime); }
public bool autoReceiveForBuyer(string receiveId, string type) { //这些数据都是系统启动之前由系统管理人员手工添加到par_set_desc表中,要和本段程序一致 string function_id = "hc_10"; //par_set_desc表中par_set_desc字段,全系统唯一的参数标识 string used_module = "9"; //url传递的子系统标识,比如订单、会员等 string location = "1"; //表示买方,卖方还是中介 string result = null; string strsql = ""; if (type.Equals("1")) { strsql = "select res.result_id " + "from par_set_result res," + "(select ord.buyer_orgid " + "from ord_order_item item, ord_order_receive receive, ord_order ord " + "where ord.order_id = item.order_id and item.record_id = receive.order_item_id and receive.id = '" + receiveId + "') t " + "where res.location = '" + location + "' and res.used_module = '" + used_module + "' and res.function_id = '" + function_id + "' and t.buyer_orgid = res.location_id"; } else { strsql = "select res.result_id " + "from par_set_result res," + "(select ord.buyer_orgid " + "from ord_order_item_non item, ord_order_receive_non receive, ord_order_non ord " + "where ord.order_id = item.order_id and item.record_id = receive.order_item_id and receive.id = '" + receiveId + "') t " + "where res.location = '" + location + "' and res.used_module = '" + used_module + "' and res.function_id = '" + function_id + "' and t.buyer_orgid = res.location_id"; } //DbParameter paramId = base.DbFacade.CreateParameter(); //paramId.ParameterName = "receive_id"; //paramId.DbType = DbType.String; //paramId.Value = receiveId; try { object o = DbFacade.SQLExecuteScalar(strsql); if (o != null) { result = o.ToString(); } else { return(getParamDefaultValue(function_id).Equals("1")?true:false); } } catch (Exception e) { throw e; } return(result.Equals("1") ? true : false);//1表示自动到货,2表示不自动到货 }
/// <summary> /// 判断是否生产企业 /// </summary> /// <param name="orgId"></param> /// <returns> /// </returns> public bool IsFactory(string orgId) { StringBuilder sql = new StringBuilder(); sql.Append("select factory_flag "); sql.Append(" from Gpo_Reg_Org "); sql.Append(" where id = '").Append(orgId).Append("'"); object result = DbFacade.SQLExecuteScalar(sql.ToString()); if ("1".Equals(result)) { return(true); } else { return(false); } }
/// <summary> /// 判断是否医院 /// </summary> /// panyj 2006-9-11 /// <param name="orgId"></param> /// <returns>true:医院;false:供应站 /// </returns> public bool isHospital(string orgId) { int c = 0; StringBuilder sql = new StringBuilder(); sql.Append("select count (1) cnt ");//定购总量 sql.Append(" from gpo_provider_buyer,gpo_usr_org "); sql.Append(" where gpo_usr_org.reg_org_id =gpo_provider_buyer.request_id and gpo_usr_org.id = '").Append(orgId).Append("'"); object result = DbFacade.SQLExecuteScalar(sql.ToString()); c = Convert.ToInt32(result); if (c > 0) { return(true); } else { return(false); } }
/// <summary> /// 检查数据是否存在 /// </summary> /// <param name="tableName">表名</param> /// <param name="pk">主键名</param> /// <param name="id">主键值</param> /// <param name="tran">事务</param> /// <returns>存在:true;不存在:false</returns> private bool CheckExist(string tableName, string pk, string id, DbTransaction tran) { string sql = "select count(*) from " + tableName + " where " + pk + "=:id"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "id"; para.DbType = DbType.AnsiString; para.Value = id; object o = DbFacade.SQLExecuteScalar(sql, tran, para); if (o != null && !o.ToString().Equals("0")) { return(true); } else { return(false); } }
/// <summary> /// 订单明细状态表数据更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckItemStatusForUpdate(DataRow dr, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select Order_Item_State from GPO_ITEM_STATUS where id = :ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "Id"; para.DbType = DbType.AnsiString; para.Value = dr["Id"]; Object o = DbFacade.SQLExecuteScalar(sql, para); if (o != null) { string state = o.ToString(); //1、判断Gpo_Order_Item中订单明细标记状态字段(Order_Item_State)为5(作废)或者7(完成),不能修改 if (state.Equals("5") || state.Equals("7")) { strInvalid = "table:GPO_ITEM_STATUS/ID:" + dr["id"] + "/状态字段为3(已确认)或5(关闭)或7(完成),不能修改!"; flag = false; } //2、订单明细状态表(ORDER_ITEM_STATE)状态字段(Order_Item_State)为3(已确认)时,不能将将状态(ITEM_STATUS)置为5(作废) else if (state.Equals("3") && dr["Order_Item_State"].ToString().Equals("5")) { strInvalid = "table:GPO_ITEM_STATUS/ID:" + dr["id"] + "/不能由3(卖方备货确认) 变为5(作废),不能修改!"; flag = false; } //3、订单明细状态表(ORDER_ITEM_STATE)状态字段(Order_Item_State)为6(缺货)时,不能将将状态(ITEM_STATUS)置为4(到货中)或者7(完成) else if (state.Equals("6") && (dr["Order_Item_State"].ToString().Equals("4") || dr["ORDER_ITEM_STATE"].ToString().Equals("7"))) { strInvalid = "table:GPO_ITEM_STATUS/ID:" + dr["id"] + "/不能由 6(缺货) 变为 4(到货中)或7(完成),不能修改!"; flag = false; } } return(flag); }
/// <summary> /// 订单明细表更新校验 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckOrderItemForUpdate(DataRow dr, out string strInvalid) { strInvalid = ""; bool flag = true; string sql = "select state from HC_ORD_ORDER where ID = :RECORD_ID"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "RECORD_ID"; para.DbType = DbType.UInt64; para.Value = dr["ORDER_ID"]; Object o = DbFacade.SQLExecuteScalar(sql, para); if (o != null) { string state = o.ToString(); //1、判断订单明细标记状态字段为6(作废)或5(完成),不能修改 if (state.Equals("6") || state.Equals("5")) { strInvalid = "table:HC_ORD_ORDER/ID:" + dr["ORDER_ID"] + "/状态字段为6(作废)或5(完成),不能修改!"; flag = false; } ////2、订单明细表(GPO_ORDER_ITEM)状态字段(ITEM_STATUS)为3(已确认)时,不能将将状态(ITEM_STATUS)置为5(作废) //else if (state.Equals("3") && dr["ITEM_STATUS"].ToString().Equals("5")) //{ // strInvalid = "table:Gpo_Order_Item/RECORD_ID:" + dr["RECORD_ID"] + "/不能由3(卖方备货确认) 变为5(作废),不能修改!"; // flag = false; //} ////3、订单明细表(GPO_ORDER_ITEM)状态字段(ITEM_STATUS)为6(缺货)时,不能将将状态(ITEM_STATUS)置为4(到货中)或者7(完成) //else if (state.Equals("6") && (dr["ITEM_STATUS"].ToString().Equals("4") || dr["ORDER_ITEM_STATE"].ToString().Equals("7"))) //{ // strInvalid = "table:Gpo_Order_Item/RECORD_ID:" + dr["RECORD_ID"] + "/不能由 6(缺货) 变为 4(到货中)或7(完成),不能修改!"; // flag = false; //} } return(flag); }
//判断产品编码是否重复 public bool JudgeHisProductCode(string productcode) { bool flag = false; string sqlstr = "select count(1) from GPO_PRODUCT_MAP_VIEW where PRODUCT_CODE='" + productcode + "'"; try { int count = Convert.ToInt16(DbFacade.SQLExecuteScalar(sqlstr).ToString()); if (count > 0) { flag = true; //重复 } } catch (Exception ex) { throw ex; } return(flag); }
public string getParamDefaultValue(string functionId) { string result = null; string sql = "select default_value from par_set_desc where rtrim(function_id) = :function_id"; DbParameter param = base.DbFacade.CreateParameter(); param.ParameterName = "function_id"; param.DbType = DbType.String; param.Value = functionId; try { object o = DbFacade.SQLExecuteScalar(sql, param); if (o != null) { result = o.ToString(); } } catch (Exception e) { throw e; } return(result); }
public string getParamValue(string functionId, string locationID, string location) { string result = null; string sql = @"select result_id from par_set_result where rtrim(function_id)=:function_id and location_id=:location_id and USED_MODULE='1' and LOCATION=:LOCATION"; DbParameter paramFun = base.DbFacade.CreateParameter(); paramFun.ParameterName = "function_id"; paramFun.DbType = DbType.String; paramFun.Value = functionId; DbParameter paramLoc = base.DbFacade.CreateParameter(); paramLoc.ParameterName = "location_id"; paramLoc.DbType = DbType.String; paramLoc.Value = locationID; DbParameter paramLocation = base.DbFacade.CreateParameter(); paramLocation.ParameterName = "LOCATION"; paramLocation.DbType = DbType.String; paramLocation.Value = location; try { object o = DbFacade.SQLExecuteScalar(sql, paramFun, paramLoc, paramLocation); if (o != null) { result = o.ToString(); } } catch (Exception e) { throw e; } return(result); }
public string getParamValue(string functionId, string locationID) { if (string.IsNullOrEmpty(locationID)) { return(getParamDefaultValue(functionId)); } string result = null; string sql = "select result_id from par_set_result where rtrim(function_id)=:function_id and location_id=:location_id"; DbParameter paramFun = base.DbFacade.CreateParameter(); paramFun.ParameterName = "function_id"; paramFun.DbType = DbType.String; paramFun.Value = functionId; DbParameter paramLoc = base.DbFacade.CreateParameter(); paramLoc.ParameterName = "location_id"; paramLoc.DbType = DbType.String; paramLoc.Value = locationID; try { object o = DbFacade.SQLExecuteScalar(sql, paramFun, paramLoc); if (o != null) { result = o.ToString(); } else { return(getParamDefaultValue(functionId)); } } catch (Exception e) { throw e; } return(result); }
/// <summary> /// 判断是否可新增经常采购目录记录 /// </summary> /// <param name="dr"></param> /// <param name="strInvalid"></param> /// <returns></returns> public bool CheckHitCommForInsert(DataRow dr, DbTransaction tran, out string strInvalid) { bool flag = true; string sql = "select g.record_id from gpo_hit_comm g where g.buyer_id = :buyer_id and g.contract_item_id = :contract_item_id"; DbParameter para = this.DbFacade.CreateParameter(); para.ParameterName = "buyer_id"; para.DbType = DbType.UInt64; para.Value = dr["buyer_id"]; DbParameter para1 = this.DbFacade.CreateParameter(); para1.ParameterName = "contract_item_id"; para1.DbType = DbType.UInt64; para1.Value = dr["contract_item_id"]; object o = DbFacade.SQLExecuteScalar(sql, tran, para, para1); strInvalid = ""; if (o != null) { flag = false; } return(flag); }