/**
* 点击CustomerInfoList中选项时，显示选中客户编号的客户信息
* @param object sender
* @param EvenArgs e
* @return void
* @author Rick
**/
private void CustomInfoList_SelectedIndexChanged(object sender, EventArgs e)
{
this.data_clear_all();
//获取选中的客户编号值
string customerNo = this.CustomInfoList.SelectedItem.ToString().Split(' ')[3];
this.customer = new Customer();
this.countfeeinfo = new Countfeeinfo();
//查询该客户的信息
if ("" != customerNo)
{
if (Constant.OK == this.customerAction.getCustomerById(customerNo, ref customer))
{
//将Customer类中的值显示在各个文本区中
//MessageBox.Show(customer.getCustomerName());
this.customerName.Text = customer.getCustomerName();
this.CustomerAddress.Text = customer.getCustomerAddress();
this.LineBox.SelectedValue = customer.getLine();
this.AreaBox.SelectedValue = customer.getArea();
this.InvoiceType.SelectedItem = customer.getInvoiceType();
this.ElectriType.SelectedItem = customer.getElectriCharacterName();
this.VoltageFlag.SelectedItem = customer.getVoltageFlag();
this.cbxAmmeterType1.SelectedItem = customer.getAmmeterType();
this.txtAmmeterNo1.Text = customer.getAmmeterNo();
this.BankCode.Text = customer.getBankCode();
this.Bank.Text = customer.getBankName();
this.BankAccount.Text = customer.getBankAccount();
if ("1" == customer.getSignFlag())
{
this.Sign.Checked = true;
this.UnSign.Checked = false;
}
else {
this.Sign.Checked = false;
this.UnSign.Checked = true;
}
this.txtPhoneNum.Text = customer.getPhoneNum();
if ("1" == customer.getLowProtectFlag().Trim())
{
this.LowProtect.Checked = true;
}
else
{
this.LowProtect.Checked = false;
}
if ("1" == customer.getTranslossOrBaseprice().Trim())
{
this.BasicEFee.Checked = true;
}
else
{
this.BasicEFee.Checked = false;
}
//this.line.Text = customer.getLine();
//this.area.Text = customer.getArea();
//this.invoiceNo.Text = customer.getInvoiceType();
//this.electriType.Text = customer.getElectriCharacterName();
//this.voltage.Text = customer.getVoltageFlag();
}
//else
//MessageBox.Show("error");
if (Constant.OK == this.customerAction.getCountFeeInfoById(customerNo, ref countfeeinfo))
{
this.ammeterMutiple.Text = countfeeinfo.getAmmeterMulti();
this.lineChange.Text = countfeeinfo.getLineLoseRate();
this.Transformer.SelectedValue = countfeeinfo.getTransformerNo();
}
//else //调试用
/// MessageBox.Show("error");
/* 查询电价信息 */
string priceSQL = "select PowerPriceNo, PriceRate from PriceRate where CustomerNo = '" + customerNo.Trim() + "'";
try
{
DataSet ds = SQLUtl.Query(priceSQL);
DataTable dt = ds.Tables[0];
int rows = dt.Rows.Count;
while (rows != 0)
{
//MessageBox.Show(rows.ToString());
switch (rows)
{
case 4:
{
this.PowerPrice_4.SelectedValue = dt.Rows[3].ItemArray[0];
this.PowerRate_4.Text = dt.Rows[3].ItemArray[1].ToString().Trim();
rows = rows - 1;
break;
}
case 3:
{
this.PowerPrice_3.SelectedValue = dt.Rows[2].ItemArray[0];
this.PowerRate_3.Text = dt.Rows[2].ItemArray[1].ToString().Trim();
rows = rows - 1;
break;
}
case 2:
{
this.PowerPrice_2.SelectedValue = dt.Rows[1].ItemArray[0];
this.PowerRate_2.Text = dt.Rows[1].ItemArray[1].ToString().Trim();
rows = rows - 1;
break;
}
case 1:
{
this.PowerPrice_1.SelectedValue = dt.Rows[0].ItemArray[0];
this.PowerRate_1.Text = dt.Rows[0].ItemArray[1].ToString().Trim();
rows = rows - 1;
break;
}
default:
{
//do nothing;
break;
}
}
}
}
catch (Exception)
{
//do nothing
}
}
}
//2015.6增加银行代收功能后，完善用户信息
private void add_Click(object sender, EventArgs e)
{
Boolean success = false;
success = checkInfo();
//如果验证不成功
if (success == false)
{
}
else
{
Customer customer = new Customer();
Countfeeinfo countfeeinfo = new Countfeeinfo();
List<Object> list = new List<object>();
//string customerPosition1 = "";
//string customerPosition2 = "";
decimal customerPosition1 = 0;
decimal customerPosition2 = 0;
if (this.CustomInfoList.SelectedIndex == -1)
{
MessageBox.Show("选择要添加客户成员的位置");
return;
}
/* 计算新添加客户的位置 */
if (this.CustomInfoList.Items.Count == (this.CustomInfoList.SelectedIndex + 1))
{
if (this.customerAction.getCustomerPositionById(this.CustomInfoList.SelectedItem.ToString().Split(' ')[3], ref customerPosition1) == Constant.OK)
{
customer.setCustomerPosition(customerPosition1 + 1);
}
}
else
{
if (this.customerAction.getCustomerPositionById(this.CustomInfoList.SelectedItem.ToString().Split(' ')[3], ref customerPosition1) == Constant.OK && this.customerAction.getCustomerPositionById(this.CustomInfoList.Items[this.CustomInfoList.SelectedIndex + 1].ToString().Split(' ')[3], ref customerPosition2) == Constant.OK)
{
customer.setCustomerPosition((customerPosition1 + customerPosition2) / 2);
}
}
if ("" == this.CustomerCode_1.Text.ToString().Trim())
{
MessageBox.Show("请选择账本信息和所要插入的位置！");
return;
}
if ("" == this.CustomerCode_2.Text.ToString().Trim())
{
MessageBox.Show("填写客户编码！");
return;
}
customer.setCustomerNo(this.CustomerCode_1.Text.ToString().Trim() + this.CustomerCode_2.Text.ToString().Trim());
if ("" == this.CustomerName.Text.ToString().Trim())
{
MessageBox.Show("请输入客户名称");
return;
}
customer.setCustomerName(this.CustomerName.Text.ToString().Trim());
customer.setCustomerAddress(this.CustomerAddress.Text.ToString());
customer.setPhoneNum(this.txtPhoneNum.Text.ToString());
customer.setLine(this.Line.SelectedValue.ToString().Trim());
customer.setAmmeterType(this.cbxAmmeterType1.SelectedItem.ToString());
customer.setAmmeterNo(this.txtAmmeterNo1.Text.ToString());
customer.setArea(this.AreaType.SelectedItem.ToString().Trim().Split(' ')[0]);
customer.setElectriCharacterName(this.ElectriType.SelectedItem.ToString().Trim());
customer.setVoltageFlag(this.VoltageFlag.SelectedItem.ToString().Trim());
customer.setInvoiceType(this.InvoiceType.SelectedItem.ToString().Trim());
//设置身份证号
customer.setIdentificationCard(this.identificationCard.Text.ToString().Trim());
//设置签约标志信息
if (this.sign.Checked)
{
customer.setSignFlag("1");
}
else
{
customer.setSignFlag("0");
}
customer.setOrganFlag("0");
customer.setEspecialFlag("0");
if (this.cbxSpecialFlag.Checked)
{
customer.setEspecialFlag("1");
}
customer.setBankAccount(this.BankAccount.Text.ToString().Trim());
customer.setBankCode(this.BankCode.Text.ToString().Trim());
customer.setBankName(this.Bank.Text.ToString().Trim());
customer.setTradeCode("");
customer.setValueAddTaxNo("");
if (this.LowProtect.Checked)
{
customer.setLowProtectFlag("1");
}
else
{
customer.setLowProtectFlag("0");
}
if (this.BasicEFee.Checked)
{
customer.setTranslossOrBaseprice("1");
}
else
{
customer.setTranslossOrBaseprice("0");
}
customer.setPassword(this.CustomerCode_1.Text.ToString().Trim() + this.CustomerCode_2.Text.ToString().Trim());
countfeeinfo.setCustomerNo(customer.getCustomerNo());
if (null == this.Transformer.SelectedItem || -1 == int.Parse(this.Transformer.SelectedItem.ToString().Trim().Split(' ')[0]))
{
countfeeinfo.setTransformerNo("0");
}
else
{
countfeeinfo.setTransformerNo(this.Transformer.SelectedItem.ToString().Trim().Split(' ')[0]);
}
countfeeinfo.setAmmeterMulti(this.Multi.Text.ToString().Trim());
countfeeinfo.setLineLoseRate(this.LineLoseRate.Text.ToString().Trim());
if ("" == this.Discount.Text.ToString().Trim())
{
countfeeinfo.setDiscountRate("0");
}
else
{
countfeeinfo.setDiscountRate(this.Discount.Text.ToString().Trim());
}
list.Add((Object)customer);
list.Add((Object)countfeeinfo);
/* 检验该客户编号是否存在 */
bool state = false;
if (Constant.OK == this.customerAction.customerNoChecking(customer.getCustomerNo(), ref state))
{
if (!state)
{
MessageBox.Show("该编号已经存在");
return;
}
}
else
{
MessageBox.Show("数据库执行出错");
return;
}
/* 添加电价比率信息 */
if (this.PowerPrice_1.SelectedIndex != -1)
{
PriceRate pr_1 = new PriceRate();
pr_1.PriceNo = int.Parse(this.PowerPrice_1.SelectedValue.ToString());
pr_1.Rate = float.Parse(this.Price1.Text.ToString().Trim());
pr_1.PriceName = customer.getCustomerNo();
list.Add((Object)pr_1);
}
if (this.PowerPrice_2.SelectedIndex != -1)
{
PriceRate pr_2 = new PriceRate();
pr_2.PriceNo = int.Parse(this.PowerPrice_2.SelectedValue.ToString());
pr_2.Rate = float.Parse(this.Price2.Text.ToString().Trim());
pr_2.PriceName = customer.getCustomerNo();
list.Add((Object)pr_2);
}
if (this.PowerPrice_3.SelectedIndex != -1)
{
PriceRate pr_3 = new PriceRate();
pr_3.PriceNo = int.Parse(this.PowerPrice_3.SelectedValue.ToString());
pr_3.Rate = float.Parse(this.Price3.Text.ToString().Trim());
pr_3.PriceName = customer.getCustomerNo();
list.Add((Object)pr_3);
}
if (this.PowerPrice_4.SelectedIndex != -1)
{
PriceRate pr_4 = new PriceRate();
pr_4.PriceNo = int.Parse(this.PowerPrice_4.SelectedValue.ToString());
pr_4.Rate = float.Parse(this.Price4.Text.ToString().Trim());
pr_4.PriceName = customer.getCustomerNo();
list.Add((Object)pr_4);
}
/*添加客户信息*/
if (Constant.OK == this.customerAction.addCustomerInfo(ref list))
{
MessageBox.Show("客户信息添加成功");
this.init_content();
return;
}
else
{
MessageBox.Show("客户信息添加失败");
return;
}
/*添加客户计费信息
if (Constant.OK == this.customerAction.addCountfeeinfo(ref countfeeinfo))
{
}
else
{
}
*/
}
}
/**
* 根据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;
}
}
private void addButton_Click(object sender, EventArgs e)
{
Customer customer = new Customer();
Countfeeinfo countfeeinfo = new Countfeeinfo();
List<Object> list = new List<object>();
/* 设置客户的位置信息 */
customer.setCustomerPosition(1);
customer.setCustomerNo(this.CustomerCode_new.Text.ToString().Trim());
if ("" == this.CustomerName_new.Text.ToString().Trim())
{
MessageBox.Show("请输入客户名称！");
return;
}
customer.setCustomerName(this.CustomerName_new.Text.ToString().Trim());
customer.setCustomerAddress(this.CustomerAddress_new.Text.ToString());
customer.setPhoneNum(this.txtPhoneNum2.Text.ToString());
customer.setLine(this.Line_new.SelectedValue.ToString().Trim());
customer.setArea(this.Area_new.SelectedItem.ToString().Trim().Split(' ')[0]);
customer.setAmmeterType(this.cbxAmmeterType2.SelectedItem.ToString());
customer.setAmmeterNo(this.txtAmmeterNo2.Text.ToString());
customer.setElectriCharacterName(this.Electri_new.SelectedItem.ToString().Trim());
customer.setVoltageFlag(this.VoltageFlag_new.SelectedItem.ToString().Trim());
customer.setInvoiceType(this.InvoiceType_new.SelectedItem.ToString().Trim());
//设置身份证号
customer.setIdentificationCard(this.identificationCard.Text.ToString().Trim());
//设置签约标志信息
if (this.sign.Checked)
{
customer.setSignFlag("1");
}
else
{
customer.setSignFlag("0");
}
customer.setOrganFlag("0");
customer.setEspecialFlag("0");
if (this.cbxSpecialFlag.Checked)
{
customer.setEspecialFlag("1");
}
customer.setBankAccount(this.BankAccount_new.Text.ToString().Trim());
customer.setBankCode(this.BankCode_new.Text.ToString().Trim());
customer.setBankName(this.BankName_new.Text.ToString().Trim());
customer.setTradeCode("");
customer.setValueAddTaxNo("");
customer.setPassword(this.CustomerCode_new.Text.ToString().Trim());
if (this.LowProtect.Checked)
{
customer.setLowProtectFlag("1");
}
else
{
customer.setLowProtectFlag("0");
}
if (this.BasicEFee.Checked)
{
customer.setTranslossOrBaseprice("1");
}
else
{
customer.setTranslossOrBaseprice("0");
}
countfeeinfo.setCustomerNo(customer.getCustomerNo());
if (null == this.Transformer_new.SelectedItem || -1 == int.Parse(this.Transformer_new.SelectedItem.ToString().Trim().Split(' ')[0]))
{
countfeeinfo.setTransformerNo("0");
}
else
{
countfeeinfo.setTransformerNo(this.Transformer_new.SelectedItem.ToString().Trim().Split(' ')[0]);
}
countfeeinfo.setAmmeterMulti(this.Multip_new.Text.ToString().Trim());
countfeeinfo.setLineLoseRate(this.LineLoseRate_new.Text.ToString().Trim());
if ("" == this.Discount_new.Text.ToString().Trim())
{
countfeeinfo.setDiscountRate("0");
}
else
{
countfeeinfo.setDiscountRate(this.Discount_new.Text.ToString().Trim());
}
list.Add((Object)customer);
list.Add((Object)countfeeinfo);
/* 检验该该账本编号是否存在 */
bool state = false;
if (Constant.OK == this.customerAction.bookTypeChecking(customer.getCustomerNo(), ref state))
{
if (!state)
{
MessageBox.Show("该账簿号已经存在");
return;
}
}
else
{
MessageBox.Show("数据库执行出错");
return;
}
/* 添加电价比率信息 */
if (this.PowerPrice1_new.SelectedIndex != -1)
{
PriceRate pr_1 = new PriceRate();
pr_1.PriceNo = int.Parse(this.PowerPrice1_new.SelectedValue.ToString());
pr_1.Rate = float.Parse(this.Price1_new.Text.ToString().Trim());
pr_1.PriceName = customer.getCustomerNo();
list.Add((Object)pr_1);
}
if (this.PowerPrice2_new.SelectedIndex != -1)
{
PriceRate pr_2 = new PriceRate();
pr_2.PriceNo = int.Parse(this.PowerPrice2_new.SelectedValue.ToString());
pr_2.Rate = float.Parse(this.Price2_new.Text.ToString().Trim());
pr_2.PriceName = customer.getCustomerNo();
list.Add((Object)pr_2);
}
if (this.PowerPrice3_new.SelectedIndex != -1)
{
PriceRate pr_3 = new PriceRate();
pr_3.PriceNo = int.Parse(this.PowerPrice3_new.SelectedValue.ToString());
pr_3.Rate = float.Parse(this.Price3_new.Text.ToString().Trim());
pr_3.PriceName = customer.getCustomerNo();
list.Add((Object)pr_3);
}
if (this.PowerPrice4_new.SelectedIndex != -1)
{
PriceRate pr_4 = new PriceRate();
pr_4.PriceNo = int.Parse(this.PowerPrice4_new.SelectedValue.ToString());
pr_4.Rate = float.Parse(this.Price4_new.Text.ToString().Trim());
pr_4.PriceName = customer.getCustomerNo();
list.Add((Object)pr_4);
}
/*添加客户信息*/
if (Constant.OK == this.customerAction.addCustomerInfo(ref list))
{
MessageBox.Show("客户信息添加成功");
this.init_content();
return;
}
else
{
MessageBox.Show("客户信息添加失败");
return;
}
}
