protected void Button2_Click(object sender, EventArgs e)
{
string receipt_id = query_receipt_id.Text;
PaymentAdapter raa = new PaymentAdapter();
show(raa.getReceiptHeads(receipt_id));
}
private void GridViewBind()
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getReceiptAuditHeads();
show(ds);
}
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string receipt_id = e.CommandArgument.ToString();
PaymentAdapter raa = new PaymentAdapter();
PaymentRequestAdapter ida = new PaymentRequestAdapter();
PaymentDepositAdapter da = new PaymentDepositAdapter();
try
{
DataSet ds = raa.getInDecreaseList(receipt_id);
ida.updateHeadCheckStatus(ds);
ds = raa.getDepositList(receipt_id);
da.updateHeadCheckStatus(ds);
raa.deleteToDone(receipt_id);
raa.deleteReceipt(receipt_id);
GridView3.SelectedIndex = -1;
GridViewBind();
Label1.Text = "删除成功";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
}
private string LoadLastPaymentId()
{
string search = "PAY" + DateTime.Now.ToString("yyyyMMdd");
PaymentAdapter pa = new PaymentAdapter();
return(pa.getLastPaymentID(search));
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string deposit_id = e.CommandArgument.ToString();
PaymentDepositAdapter pda = new PaymentDepositAdapter();
PaymentAdapter pa = new PaymentAdapter();
try
{
bool result = pa.depositIsUsed(deposit_id);
if (result)
{
Label1.Text = "该定金单已经被使用，不能删除！";
return;
}
else
{
pda.delete(deposit_id);
pda.deleteToDone(deposit_id);
GridViewBind();
clean();
GridViewEmptyBind();
Label1.Text = "删除成功";
}
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
}
private int getCusIDByName(string name)
{
PaymentAdapter raa = new PaymentAdapter();
int id = raa.getIDByName(name);
return(id);
}
protected void btn_save_Click(object sender, EventArgs e)
{
T_PaymentRequest item = new T_PaymentRequest();
item.PaymentId = hdf_payment_id.Value;
item.PaymentDate = DateTime.ParseExact(d_date.Text, "yyyy年MM月dd日", System.Globalization.CultureInfo.CurrentCulture);
item.PayeeUnit = txt_payee_unit.Text;
item.Amount = Decimal.Parse(txt_amount.Text);
item.PayeeOpeningBank = txt_opening_bank.Text;
item.PayeeAccountId = txt_account_id.Text;
item.CustomerBillNo = txt_icsale_id.Text;
item.FactoryBillNo = txt_poorder_id.Text;
item.GoodsModel = txt_goods_model.Text;
item.PaymentExplain = txt_payment_explain.Text;
item.Note = txt_note.Text;
item.DeptName = txt_dept_name.Text;
item.EmpName = txt_emp_name.Text;
item.IsUserd = false;
PaymentAdapter pa = new PaymentAdapter();
try
{
pa.insert(item);
Label1.Text = "保存成功";
clean();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
return;
}
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
SetContentView(Resource.Layout.Payment);
Android.Support.V7.Widget.Toolbar toolbar = FindViewById <Android.Support.V7.Widget.Toolbar>(Resource.Id.toolbar);
SetSupportActionBar(toolbar);
var textViewName = FindViewById <TextView>(Resource.Id.textViewName);
var textViewAmount = FindViewById <TextView>(Resource.Id.textViewAmount);
listView = FindViewById <ListView>(Resource.Id.listView1);
tripFriends = JsonConvert.DeserializeObject <ObservableCollection <UserItem> >(Intent.GetStringExtra("Friends"));
paymentItem = JsonConvert.DeserializeObject <PaymentItem>(Intent.GetStringExtra("PaymentItem"));
tripItem = JsonConvert.DeserializeObject <TripItem>(Intent.GetStringExtra("TripItem"));
GetPaymentUser();
textViewName.Text = paymentItem.Name;
textViewAmount.Text = "" + paymentItem.Amount;
var adapter = new PaymentAdapter(this, paymentContributors, tripFriends);
listView.Adapter = adapter;
var swipeContainer = FindViewById <SwipeRefreshLayout>(Resource.Id.swipeContainer);
swipeContainer.SetColorSchemeResources(Android.Resource.Color.HoloBlueLight, Android.Resource.Color.HoloGreenLight, Android.Resource.Color.HoloOrangeLight, Android.Resource.Color.HoloRedLight);
swipeContainer.Refresh += SwipeContainer_Refresh;
}
private string LoadLastReceiptID()
{
string search = "FKDJ" + DateTime.Now.Year.ToString().Substring(2, 2);
PaymentAdapter raa = new PaymentAdapter();
return(raa.getLastReceiptID(search));
}
void SwipeContainer_Refresh(object sender, EventArgs e)
{
GetPaymentUser();
var adapter = new PaymentAdapter(this, paymentContributors, tripFriends);
listView.Adapter = adapter;
(sender as SwipeRefreshLayout).Refreshing = false;
}
private async void GetPaymentUser()
{
paymentContributors = await DatabaseManager.DefaultManager.GetPaymentUsersForPaymentAsync(paymentItem);
var adapterPayemnt = new PaymentAdapter(this, paymentContributors, tripFriends);
listView.Adapter = adapterPayemnt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string payment_id = Request.QueryString["id"].ToString();
PaymentAdapter pa = new PaymentAdapter();
DataSet ds = pa.getPaymentByID(payment_id);
WebDataBind(ds);
}
}
private void GridViewBind(int id, string name, int currencyID)
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds1 = raa.getUnCheckReceiptLists(id, currencyID);
DataSet ds2 = raa.getDoneBillNos(name);
DataTable dt = sub(ds1, ds2);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
string receipt_id = query_receipt_id.Text;
string customer_name = txt_customer.Text;
string start_time = CalendarBox1.Text;
string end_time = CalendarBox2.Text;
PaymentAdapter raa = new PaymentAdapter();
show(raa.queryReceiptHeads(receipt_id, customer_name, start_time, end_time));
}
private string getCusIDByName(string name)
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getSupplierInfoByName(name);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0]["FNumber"].ToString());
}
else
{
return(string.Empty);
}
}
private void DepositBind(string receipt_id)
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getDepositList(receipt_id);
if (ds.Tables[0].Rows.Count == 0)
{
GridView3EmptyBind();
}
else
{
GridView3.DataSource = ds;
GridView3.DataBind();
}
}
private void InDecreaseBind(string receipt_id)
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getInDecreaseList(receipt_id);
if (ds.Tables[0].Rows.Count == 0)
{
GridView2EmptyBind();
}
else
{
GridView2.DataSource = ds;
GridView2.DataBind();
}
}
public void Wrap_Stripe_To_Support_Interface_That_Program_Expects()
{
// Client code (e.g. Program) needs to work with IPaymentAdapter, which exposes Charge(string, decimal).
// IStripe exposes ChargeCreditCard(string, decimal), therefore client code can't work directly with IStripe.
// IPaymentAdapter acts as the "middle man" between Program and IStripe.
// From this point foward, all client code (e.g. Program) is only dependent on IPaymentAdapter, so Stripe can be replaced with something else without modifying client code.
// Analogy for Adapter Pattern is a travel power adapter that's used between a power outlet and a device power input.
var stripe = new Mock <IStripe>();
var paymentAdapter = new PaymentAdapter(stripe.Object);
var program = new Program(paymentAdapter);
program.Run("12345", 100);
stripe.Verify(s => s.ChargeCreditCard("id:12345", 100), Times.Once());
}
private void show()
{
string fbillno = txt_fbillno_id.Text.Trim();
string start_time = cb_start_time.Text;
string end_time = cb_end_time.Text;
string customer = txt_customer.Text.Trim();
string check_status = ddl_check_status.SelectedValue;
PaymentAdapter raa = new PaymentAdapter();
DataSet ds1 = raa.getICPurChaseList(start_time, end_time, fbillno, customer, check_status);
DataSet ds2 = raa.getICPurChaseListFromKindDee(start_time, end_time, fbillno, customer, check_status);
DataTable ds = sub(ds2, ds1);
ds.Merge(ds1.Tables[0]);
ds = order(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
public CraftgateClient(string apiKey, string secretKey, string baseUrl)
{
var requestOptions = new RequestOptions
{
ApiKey = apiKey,
SecretKey = secretKey,
BaseUrl = baseUrl
};
_installmentAdapter = new InstallmentAdapter(requestOptions);
_onboardingAdapter = new OnboardingAdapter(requestOptions);
_paymentAdapter = new PaymentAdapter(requestOptions);
_paymentReportingAdapter = new PaymentReportingAdapter(requestOptions);
_walletAdapter = new WalletAdapter(requestOptions);
_settlementAdapter = new SettlementAdapter(requestOptions);
_settlementReportingAdapter = new SettlementReportingAdapter(requestOptions);
_payByLinkApiAdapter = new PayByLinkApiAdapter(requestOptions);
_fileReportingAdapter = new FileReportingAdapter(requestOptions);
}
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string[] args = e.CommandArgument.ToString().Split(',');
string receipt_id = args[0];
string receipt_type = args[1];
PaymentAdapter raa = new PaymentAdapter();
PaymentRequestAdapter ida = new PaymentRequestAdapter();
PaymentDepositAdapter da = new PaymentDepositAdapter();
PaymentInDecreaseAdapter pia = new PaymentInDecreaseAdapter();
try
{
DataSet ds = raa.getInDecreaseList(receipt_id);
pia.updateHeadCheckStatus(ds);
ds = raa.getDepositList(receipt_id);
if (receipt_type == "B")
{
da.updateHeadIsPayed(ds);
}
else
{
da.updateHeadCheckStatus(ds);//更新定金单的check_status值；
}
ds = raa.getRequestList(receipt_id);
ida.updateHeadCheckStatus(ds);
raa.deleteToDone(receipt_id);
raa.deleteReceipt(receipt_id);
GridView3.SelectedIndex = -1;
GridViewBind();
Label1.Text = "删除成功";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
}
protected void btn_audit_Click(object sender, EventArgs e)
{
Button bt = sender as Button;
string args = bt.CommandArgument.ToString();
GridViewRow row = bt.Parent.Parent as GridViewRow;
HyperLink thisData = row.Cells[1].Controls[0] as HyperLink;
string receipt_id = thisData.Text;
PaymentAdapter raa = new PaymentAdapter();
T_PaymentReceiptHead head = new T_PaymentReceiptHead();
head.ReceiptId = receipt_id;
T_AccountLog account_log = new T_AccountLog();
account_log.ReceiptId = receipt_id;
account_log.AccountId = (bt.Parent.FindControl("hdf_account_id") as HiddenField).Value;
account_log.Operater = UserInfoAdapter.CurrentUser.Name;
account_log.OperateTime = DateTime.Now;
account_log.Amount = Decimal.Parse(row.Cells[5].Text);
AccountLogAdapter ala = new AccountLogAdapter();
if (args == "Y")
{
account_log.Amount *= -1;
head.AuditStatus = 3;//通过
//更新账户金额
}
else
{
head.AuditStatus = 2;//不通过
}
ala.insert(account_log);
ala.Add(account_log);
raa.updateReceiptHeadAuditStatus(head);
GridViewBind();
}
private void HeadBind(string receipt_id)
{
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getReceiptHeads(receipt_id);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
txt_customer.Text = dr["customer_name"].ToString();
d_date.Text = DateTime.Parse(dr["receipt_date"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
string currencyID = dr["currency"].ToString();
ddl_currency.SelectedValue = currencyID;
txt_amount.Text = Decimal.Parse(dr["amount"].ToString()).ToString("0.00");
if (!string.IsNullOrEmpty(dr["receipt_charge"].ToString()))
{
txt_receipt_charge.Text = Decimal.Parse(dr["receipt_charge"].ToString()).ToString("0.00");
}
ddl_receipt_type.SelectedValue = dr["receipt_type"].ToString();
if (dr["receipt_type"].ToString() != "A" && dr["receipt_type"].ToString() != "B")
{
txt_amount.Enabled = true;
}
txt_account.Text = dr["account_id"].ToString();
ddl_preparer.SelectedValue = dr["FPreparer"].ToString();
ddl_checker.SelectedValue = dr["FChecker"].ToString();
check_date.Text = DateTime.Parse(dr["FCheckDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
//通过审核后不让其修改
string audit_status = dr["audit_status"].ToString();
if (!string.IsNullOrEmpty(audit_status) && audit_status == "3")
{
updateUser.Enabled = false;
}
txt_note.Text = dr["note"].ToString();
}
}
protected void add_Click(object sender, EventArgs e)
{
Label1.Text = "";
//表头
T_PaymentDepositHead head = new T_PaymentDepositHead();
head.DepositId = txt_deposit_id.Text;
head.Customer = customer.Text;
CommonAdapter ca = new CommonAdapter();
head.Agenter = ca.getEmpNameByID(Int32.Parse(ddl_agenter.SelectedValue));
head.CheckStatus = 0;
head.CurrencyID = ddl_currency.SelectedValue;
head.AmountAll = Decimal.Parse(txt_amount_all.Text);
head.UnpayAmountFor = Decimal.Parse(txt_amount_all.Text);
string str_agent_date = agent_date.Text;
if (!string.IsNullOrEmpty(str_agent_date))
{
head.AgentDate = DateTime.Parse(str_agent_date);
}
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getSupplierInfoByName(head.Customer);
if (ds.Tables[0].Rows.Count > 0)
{
head.CustomerID = Int32.Parse(ds.Tables[0].Rows[0]["FNumber"].ToString());
head.ItemID = Int32.Parse(ds.Tables[0].Rows[0]["FItemID"].ToString());
}
else
{
Label1.Text = "供应商姓名请输入关键字后从下拉框选择！";
return;
}
//表体
List <T_PaymentDepositList> lists = new List <T_PaymentDepositList>();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
T_PaymentDepositList list = new T_PaymentDepositList();
list.DepositId = head.DepositId;
list.GNo = Int32.Parse((GridView1.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text);
string fbillno = (GridView1.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
if (string.IsNullOrEmpty(fbillno))
{
continue;
}
list.FBillNo = fbillno;
list.Fdate = DateTime.Parse((GridView1.Rows[i].Cells[2].FindControl("lbl_fdate") as Label).Text);
list.Amount = Decimal.Parse((GridView1.Rows[i].Cells[3].FindControl("lbl_amountfor") as Label).Text);
list.Note = (GridView1.Rows[i].Cells[4].FindControl("txt_note") as TextBox).Text;
lists.Add(list);
}
List <T_PaymentDepositList> addtodonelists = addBillNoToDone(lists, head);
try
{
//保存数据
PaymentDepositAdapter da = new PaymentDepositAdapter();
da.addDepositHead(head);
da.insertDepositList(lists);
//TODO:更新销售发票的check_status,增减单的check_status
da.addToDone(addtodonelists);
Label1.Text = "哟，小伙子，不错，被你录入成功了";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
protected void updateUser_Click(object sender, EventArgs e)
{
Label1.Text = "";
T_PaymentReceiptHead head = new T_PaymentReceiptHead();
head.CustomerName = txt_customer.Text;
head.CustomerCode = string.Empty;
head.ReceiptId = txt_recetpt_no.Text;
head.ReceiptDate = DateTime.Parse(d_date.Text);
head.ReceiptType = ddl_receipt_type.SelectedValue;
//货款时供应商才从金蝶里读取
if (head.ReceiptType == "A" || head.ReceiptType == "B")
{
if (!string.IsNullOrEmpty(head.CustomerName))
{
head.CustomerCode = getCusIDByName(head.CustomerName);
if (string.IsNullOrEmpty(head.CustomerCode))
{
Label1.Text = "输入的公司名称不对，请输入关键字然后从下拉框中选择！";
return;
}
}
}
if (!String.IsNullOrEmpty(txt_amount.Text) && Decimal.Parse(txt_amount.Text) > 0)
{
head.Amount = Decimal.Parse(txt_amount.Text);
}
else
{
Label1.Text = "该收款单金额不能为空或0。";
return;
}
head.Currency = ddl_currency.SelectedValue;
if (!string.IsNullOrEmpty(txt_receipt_charge.Text))
{
head.ReceiptCharge = Decimal.Parse(txt_receipt_charge.Text);
}
head.FPreparer = Int32.Parse(ddl_preparer.SelectedValue);
head.FChecker = Int32.Parse(ddl_checker.SelectedValue);
head.FCheckDate = DateTime.Parse(check_date.Text);
head.FCheckStatus = (int)2;
head.Note = txt_note.Text;
CommonAdapter ca = new CommonAdapter();
List <T_PaymentReceiptList> lists = new List <T_PaymentReceiptList>();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
T_PaymentReceiptList list = new T_PaymentReceiptList();
list.ReceiptId = head.ReceiptId;
list.ReceiptNo = Int32.Parse(GridView1.Rows[i].Cells[0].Text);
list.FBillNo = GridView1.Rows[i].Cells[1].Text;
list.FDate = DateTime.Parse(GridView1.Rows[i].Cells[2].Text);
list.FPurchaseAmountFor = Decimal.Parse(GridView1.Rows[i].Cells[3].Text);
list.FPayAmountFor = Decimal.Parse(GridView1.Rows[i].Cells[4].Text);
list.FUnPayAmountFor = Decimal.Parse(GridView1.Rows[i].Cells[5].Text);
string fcheckamountfor = (GridView1.Rows[i].Cells[6].FindControl("txt_fcheckamountfor") as TextBox).Text;
if (string.IsNullOrEmpty(fcheckamountfor))
{
Label1.Text = "支付金额不能为空";
return;
}
list.FCheckAmountFor = Decimal.Parse(fcheckamountfor);
list.FCurrencyID = ca.getIDByCurrency(GridView1.Rows[i].Cells[7].Text);
list.FNote = (GridView1.Rows[i].Cells[8].FindControl("txt_note") as TextBox).Text;
if (list.FUnPayAmountFor - list.FCheckAmountFor == 0)
{
list.FCheckStatus = 2;
}
else
{
list.FCheckStatus = 1;
head.FCheckStatus = 1;
}
lists.Add(list);
}
for (int i = 0; i < GridView2.Rows.Count; i++)
{
T_PaymentReceiptList list = new T_PaymentReceiptList();
list.ReceiptId = head.ReceiptId;
string g_no = (GridView2.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text;
if (string.IsNullOrEmpty(g_no) || g_no == " ")
{
break;
}
list.ReceiptNo = Int32.Parse(g_no);
list.IndecreaseNo = (GridView2.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
list.FPurchaseAmountFor = Decimal.Parse((GridView2.Rows[i].Cells[3].FindControl("lbl_amount_all") as TextBox).Text);
lists.Add(list);
}
for (int i = 0; i < GridView4.Rows.Count; i++)
{
T_PaymentReceiptList list = new T_PaymentReceiptList();
list.ReceiptId = head.ReceiptId;
list.ReceiptNo = Int32.Parse((GridView4.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text);
list.RequestID = (GridView4.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
list.FPurchaseAmountFor = Decimal.Parse((GridView4.Rows[i].Cells[3].FindControl("lbl_amount_all") as Label).Text);
lists.Add(list);
}
List <T_PaymentReceiptList> listsFromDeposit = new List <T_PaymentReceiptList>();
foreach (GridViewRow gvr in GridView3.Rows)
{
T_PaymentReceiptList list = new T_PaymentReceiptList();
list.ReceiptId = head.ReceiptId;
list.ReceiptNo = Int32.Parse((gvr.Cells[0].FindControl("lbl_gno") as Label).Text);
string deposit_id = (gvr.Cells[1].FindControl("txt_deposit_id") as TextBox).Text;
if (string.IsNullOrEmpty(deposit_id))
{
continue;
}
list.DepositId = deposit_id;
list.FDate = DateTime.Parse((gvr.Cells[2].FindControl("lbl_agent_date") as Label).Text);
list.FNote = (gvr.Cells[9].FindControl("txt_note") as TextBox).Text;
list.FCurrencyID = ca.getIDByCurrency((gvr.Cells[7].FindControl("lbl_fcurrencyid") as Label).Text);
list.FPurchaseAmountFor = Decimal.Parse((gvr.Cells[3].FindControl("lbl_amount_all") as Label).Text);
list.FPayAmountFor = Decimal.Parse((gvr.Cells[4].FindControl("lbl_fpayamountfor") as Label).Text);
list.FUnPayAmountFor = Decimal.Parse((gvr.Cells[5].FindControl("lbl_funpayamountfor") as Label).Text);
string str_deposit_checkamountfor = (gvr.Cells[6].FindControl("txt_deposit_checkamountfor") as TextBox).Text;
if (string.IsNullOrEmpty(str_deposit_checkamountfor))
{
Label1.Text = "支付金额不能为空";
return;
}
list.FCheckAmountFor = Decimal.Parse(str_deposit_checkamountfor);
if (list.FUnPayAmountFor - list.FCheckAmountFor == 0)
{
list.FCheckStatus = 2;
}
else
{
list.FCheckStatus = 1;
head.FCheckStatus = 1;
}
listsFromDeposit.Add(list);
}
List <T_PaymentReceiptList> addtodonelists = addBillNoToDone(lists, head);
List <T_PaymentReceiptList> checkStatusLists = addInDecreaseNoToDone(lists);
try
{
//更新数据
PaymentAdapter raa = new PaymentAdapter();
PaymentDepositAdapter da = new PaymentDepositAdapter();
raa.updateReceiptHead(head);
raa.updateReceiptList(lists);
raa.updateReceiptList(listsFromDeposit);
//TODO:更新销售发票的check_status,增减单的check_status
raa.updateToDone(addtodonelists);//把采购发票号加入已做列表中
if (ddl_receipt_type.SelectedValue == "B")
{
da.updateHeadIsPayed(listsFromDeposit);
}
else
{
da.updateHeadCheckStatus(listsFromDeposit);//更新定金单的check_status值；
}
Label1.Text = "更新成功了";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
protected void add_Click(object sender, EventArgs e)
{
//表头
T_PaymentIndecreaseHead head = new T_PaymentIndecreaseHead();
head.AgentDate = DateTime.Parse(agent_date.Text);
head.BillNo = bill_no.Text;
head.Customer = customer.Text;
head.Agenter = agent_name.Text;
head.CheckStatus = 0;
head.CurrencyID = ddl_currency.SelectedValue;
decimal amount_all = 0;
PaymentAdapter raa = new PaymentAdapter();
DataSet ds = raa.getSupplierInfoByName(head.Customer);
if (ds.Tables[0].Rows.Count > 0)
{
head.CustomerID = Int32.Parse(ds.Tables[0].Rows[0]["FNumber"].ToString());
head.ItemID = Int32.Parse(ds.Tables[0].Rows[0]["FItemID"].ToString());
}
else
{
Label1.Text = "供应商姓名请输入关键字后从下拉框选择！";
return;
}
//表体
DataTable dt = DefineDataTableSchema(hfRptColumns.Value);
foreach (RepeaterItem item in rptTest.Items)
{
DataRow newRow = dt.NewRow();
string name = ((TextBox)item.FindControl("txt_name")).Text;
if (string.IsNullOrEmpty(name))
{
//如果项号是空，则过滤此条记录
continue;
}
string amount = ((TextBox)item.FindControl("txt_amount")).Text;
if (string.IsNullOrEmpty(amount))
{
//如果项号是空，则过滤此条记录
continue;
}
string apply_date = ((TextBox)item.FindControl("cb_apply_date")).Text;
if (string.IsNullOrEmpty(apply_date))
{
//如果项号是空，则过滤此条记录
continue;
}
string type = ((DropDownList)item.FindControl("ddl_type")).SelectedValue;
if (string.IsNullOrEmpty(type))
{
//如果项号是空，则过滤此条记录
continue;
}
newRow["g_no"] = ((TextBox)item.FindControl("txt_g_no")).Text;
newRow["name"] = name;
newRow["amount"] = amount;
newRow["apply_date"] = apply_date;
newRow["type"] = type;
if (type == "R")
{
amount_all += Decimal.Parse(amount) * -1;
}
else
{
amount_all += Decimal.Parse(amount);
}
newRow["note"] = ((TextBox)item.FindControl("txt_note")).Text;;
newRow["bill_no"] = bill_no.Text;
dt.Rows.Add(newRow);
}
head.AmountAll = amount_all;
try
{
PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();
ida.insertInDecreaseList(dt);
ida.addInDecreaseHead(head);
clean();
Label1.Text = "哟，小伙子，不错，被你录入成功了";
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
