/// <summary> /// 【土方】获取相应的工程要求参数 /// </summary> /// <param name="oYQCS">用户录入的值</param> /// <returns>库中的工程要求参数</returns> protected string getGCYCCS(object oYQCS, BHTYPE eBHTYPE) { DataTable dt = (this.GCYQCSbindingSource.DataSource as DataTable).DefaultView.ToTable(); return(this.GetFWBySZ(oYQCS, eBHTYPE, dt, "YQ")); //if (toString(oYQCS).Split('~').Length != 2) //{ // decimal dYQCS = ToolKit.ParseDecimal(oYQCS); // foreach (DataRowView item in this.GCYQCSbindingSource.List) // { // string[] arrStr = toString(item["YQ"]).Split('~'); // if (arrStr.Length != 2) { continue; } // switch (eBHTYPE) // { // case BHTYPE.全部包含: // if (dYQCS >= ToolKit.ParseDecimal(arrStr[0]) && dYQCS <= ToolKit.ParseDecimal(arrStr[1])) // { // return toString(item["YQ"]); // } // break; // case BHTYPE.只包含前项: // if (dYQCS >= ToolKit.ParseDecimal(arrStr[0]) && dYQCS < ToolKit.ParseDecimal(arrStr[1])) // { // return toString(item["YQ"]); // } // break; // } // } //} //return toString(oYQCS); }
/// <summary> /// 根据数值获取范围 /// </summary> /// <param name="oYQCS">用户录入的值</param> /// <param name="BHTYPE">包含类型【全部包含,只包含前项】</param> /// <param name="dtTemp">数据源</param> /// <param name="strColName">判断的字段</param> /// <returns>库中的工程要求参数</returns> protected string GetFWBySZ(object oYQCS, BHTYPE eBHTYPE, DataTable dtTemp, string strColName) { if (toString(oYQCS).Split('~').Length != 2) { if (!dtTemp.Columns.Contains(strColName)) { return(toString(oYQCS)); } decimal dYQCS = ToolKit.ParseDecimal(oYQCS); foreach (DataRow item in dtTemp.Rows) { string[] arrStr = toString(item[strColName]).Split('~'); if (arrStr.Length != 2) { continue; } switch (eBHTYPE) { case BHTYPE.全部包含: if (dYQCS >= ToolKit.ParseDecimal(arrStr[0]) && dYQCS <= ToolKit.ParseDecimal(arrStr[1])) { return(toString(item[strColName])); } break; case BHTYPE.只包含前项: if (dYQCS >= ToolKit.ParseDecimal(arrStr[0]) && dYQCS < ToolKit.ParseDecimal(arrStr[1])) { return(toString(item[strColName])); } break; } } } return(toString(oYQCS)); }