/** * 根据customerNo获取客户计费的相关信息 * @param string customerNo:客户编号 * @param ref Countfeeinfo countfeeinfo:客户计费信息类的引用 * @return int 值为Constant.OK:执行成功,值为Constant.ERROR为执行出错 * @author Rick **/ public int getCountFeeInfoById(string customerNo, ref Countfeeinfo countfeeinfo) { string strSql = "select * from CountFeeInfo where CustomerNo = '" + customerNo + "'"; DataSet ds = null; try { ds = SQLUtl.Query(strSql); } catch (Exception) { return Constant.ERROR; } if (null != ds && ds.Tables[0].Rows.Count != 0) { DataTable dt = ds.Tables[0]; countfeeinfo.setCustomerNo(null != dt.Rows[0].ItemArray[0] ? dt.Rows[0].ItemArray[0].ToString() : ""); //countfeeinfo.setTransformerNo(null != dt.Rows[0].ItemArray[1] && dt.Rows[0].ItemArray[1].ToString().Trim() != "0".Trim() ? dt.Rows[0].ItemArray[1].ToString() : "空"); /*查找变压器编号所对应的变压器名称*/ /* if (!(countfeeinfo.getTransformerNo().Trim() == "0".Trim() || countfeeinfo.getTransformerNo().Trim() == "空".Trim())) { string sqlForTF = "select * from TransformerInfo where TransformerNo = " + countfeeinfo.getTransformerNo().Trim() + ""; DataSet ds_tf = null; try { ds_tf = SQLUtl.Query(sqlForTF); } catch (Exception) { // } if (null != ds_tf && ds_tf.Tables[0].Rows.Count != 0) { countfeeinfo.setTransformerNo(null != ds_tf.Tables[0].Rows[0].ItemArray[1] ? ds_tf.Tables[0].Rows[0].ItemArray[1].ToString() : ""); } }*/ countfeeinfo.setTransformerNo(null != dt.Rows[0].ItemArray[1] ? dt.Rows[0].ItemArray[1].ToString() : ""); countfeeinfo.setAmmeterMulti(null != dt.Rows[0].ItemArray[2] ? dt.Rows[0].ItemArray[2].ToString() : ""); countfeeinfo.setAmmeterVolume(null != dt.Rows[0].ItemArray[3] ? dt.Rows[0].ItemArray[3].ToString() : ""); countfeeinfo.setLineLoseRate(null != dt.Rows[0].ItemArray[4] ? dt.Rows[0].ItemArray[4].ToString() : ""); countfeeinfo.setEssenceFee(null != dt.Rows[0].ItemArray[5] ? dt.Rows[0].ItemArray[5].ToString() : ""); countfeeinfo.setCountFeeInfoDate(null != dt.Rows[0].ItemArray[6] ? dt.Rows[0].ItemArray[6].ToString() : ""); countfeeinfo.setDiscountRate(null != dt.Rows[0].ItemArray[7] ? dt.Rows[0].ItemArray[7].ToString() : ""); return Constant.OK; } else { return Constant.ERROR; } }