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