/**
* 根据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;
}
}
