根据字段查询表代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】根据字段查询表

作者:robortly / 发布于2014/11/7/ 601


	public DataRow GetT_ProductByProdCode(string ProdCode, int distributorID, bool showDisabled, bool showDisabled2, bool showSaleDisabled, bool showPODisabled)
	 {
	 DataRow[] foundRows;
	 DataTable dtData = this.GetT_ProductList(distributorID);
	
	 if (dtData == null)
	 return null;
	 else
	 {
	 string strSearch = "(ProdCode='" + ProdCode + "' or ProdCode_UD='" + ProdCode + "' or ProdBarCode='" + ProdCode + "' or MinProdBarCode='" + ProdCode + "')";//description:增加外包装条形码ProdBarCode，最小单位条形码MinProdBarCode字段作为检索条件,modified by dengfeifei,date:2013-08-23
	
	 if (!showDisabled)
	 strSearch += " and Disabled = 0";
	 if (!showDisabled2)
	 strSearch += " and Disabled2 = 0";
	 if (!showSaleDisabled)
	 strSearch += " and SaleDisabled = 0";
	 if (!showPODisabled)
	 strSearch += " and PODisabled = 0";
	 foundRows = dtData.Select(strSearch);
	
	 if (foundRows.Length > 0)
	 return foundRows[0];
	 else
	 {
	 //add by luoyong 141025 添加可以检索ProdCode_SAP SAP代码的检索。
	 string stringSAP = ProdCode;
	 strSearch = "(ProdCode_SAP='" + stringSAP + "' or ProdCode_UD='" + ProdCode + "' or ProdBarCode='" + ProdCode + "' or MinProdBarCode='" + ProdCode + "')";
	 if (!showDisabled)
	 strSearch += " and Disabled = 0";
	 if (!showDisabled2)
	 strSearch += " and Disabled2 = 0";
	 if (!showSaleDisabled)
	 strSearch += " and SaleDisabled = 0";
	 if (!showPODisabled)
	 strSearch += " and PODisabled = 0";
	 foundRows = dtData.Select(strSearch);
	 if (foundRows.Length>0)
	 {
	 return foundRows[0];
	 }
	 else
	 {
	 return null;
	 }
	 }
	 }
	 }

试试其它关键字

同语言下

可能有用的

robortly贡献的其它代码(2)