返回首页

您好,
我米DIS平台的新用户。 u能帮助我,我有

rctPayment
{C}我想减,其结果是数组类型的小数肌的商店,所以我使用此代码,所以我得到这个错误
不能隐式转换类型'小数'十进制[]"请帮我........

private void button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection("Data Source=localhost;User ID=test;Initial Catalog=SQL;password=sa;");

            SqlCommand cmd = new SqlCommand("select RctDate,RctNo,CustomerCode,Amt from FocusReceipts;Select * from(Select date,invoice,customerCode,customer,gross,salesmancode,salesmanName,0 as Status from FocusInvoiceForSC union all Select  date,invoice,customerCode,customer,gross,salesmancode,salesmanName,0 as Status from CustomersOpening)BillingDetail order by date;Select distinct CustomerCode from FocusReceipts", con);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            da.Fill(ds);

 

            string billNo = string.Empty;

 

            for (int counter = 0; counter < ds.Tables[2].Rows.Count; counter++)

            {

                String customerCode=ds.Tables[2].Rows[counter]["CustomerCode"].ToString();

 

                DataRow []drPayment = ds.Tables[0].Select("CustomerCode='" + customerCode +"'");

                for (int rctCounter = 0; rctCounter < drPayment.Length; rctCounter++)

                {

                    decimal rctPayment= decimal.Parse(drPayment[rctCounter]["Amt"].ToString());

                    DataRow[] drBills = ds.Tables[1].Select("CustomerCode='" + customerCode + "' and invoice not in ('" + billNo + "')");

 

                    for (int billCounter = 0; billCounter < drBills.Length; billCounter++)

                    {

                        decimal billPayment = decimal.Parse(drBills[billCounter]["Gross"].ToString());

 

                       // decimal Adjustpayment = rctPayment - billPayment;

                        decimal[] AdjustPayment =rctPayment-billPayment;

                        for (int i = 0; i <  AdjustPayment.Length; i++)

                        {

                            decimal Adjustment =decimal.Parse( AdjustPayment[i].ToString());

                        }

                       

                      

                      

 



 

                        billNo = "'" + drBills[billCounter]["Invoice"].ToString() + "',";

                    }

                    if (billNo.Length > 0) { billNo = billNo.Substring(0, billNo.Length - 1); }

                } 

            }

        }
:8357723 |会员

回答

评论会员: 时间:2