protected void btnSave_Click(object sender, EventArgs e) { CompanyBank item = null; ICompanyBankService userService = IoC.Resolve <ICompanyBankService>(); if (user_id > 0)//修改 { item = userService.Get(this.user_id); } else { item = new CompanyBank(); } if (string.IsNullOrEmpty(this.txtBankNo.Text)) { Warning("请填写银行账号!"); return; } if (string.IsNullOrEmpty(this.txtBankOwner.Text)) { Warning("请填写开户人!"); return; } var utag = this.drpBanks.SelectedValue; item.BankId = int.Parse(utag.ToString()); item.BankNo = this.txtBankNo.Text; item.BankOwner = this.txtBankOwner.Text; item.Branch = this.txtBranch.Text; item.IsEnable = cmbStatus.SelectedValue == "1" ? true : false; item.OccDate = DateTime.Now; item.Province = this.txtProvince.Text; bool isCompled = false; if (user_id > 0) { userService.Save(); isCompled = true; } else { isCompled = userService.Add(item); } if (isCompled) { JsAlert("保存成功!", true); this.txtBankNo.Text = string.Empty; this.txtBankOwner.Text = string.Empty; this.txtBranch.Text = string.Empty; this.txtProvince.Text = string.Empty; } else { JsAlert("保存失败,请稍后再试!"); // } }
private void btnOk_Click(object sender, EventArgs e) { if (MessageBox.Show("ต้องการ บันทึกช้อมูล ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { setCompany(); String re = xC.xtDB.copDB.insertCompany(cop, xC.userId); int chk = 0; if (int.TryParse(re, out chk)) { for (int i = 1; i < grfCopBnk.Rows.Count; i++) { if (grfCopBnk[i, colBedit] == null) { continue; } if (grfCopBnk[i, colBedit].ToString().Equals("1")) { CompanyBank copb = new CompanyBank(); copb.comp_bank_id = grfCopBnk[i, colBID] != null ? grfCopBnk[i, colBID].ToString() : ""; copb.comp_bank_name_t = grfCopBnk[i, colBBnkNameT] != null ? grfCopBnk[i, colBBnkNameT].ToString() : ""; copb.comp_bank_branch = grfCopBnk[i, colBBnkBranch] != null ? grfCopBnk[i, colBBnkBranch].ToString() : ""; copb.acc_number = grfCopBnk[i, colBaccnumber] != null ? grfCopBnk[i, colBaccnumber].ToString() : ""; copb.remark = grfCopBnk[i, colBRemark] != null ? grfCopBnk[i, colBRemark].ToString() : ""; copb.bank_id = xC.iniDB.bnkDB.getIdByName(copb.comp_bank_name_t); copb.comp_id = txtID.Text; xC.iniDB.copbDB.insertCompany(copb, xC.userId); } } } //setGrdView(); } }
public String update(CompanyBank p, String userId) { String re = "", sql = ""; chkNull(p); sql = "Update " + copB.table + " Set " + " " + copB.comp_id + "='" + p.comp_id + "' " + "," + copB.comp_bank_name_t + "='" + p.comp_bank_name_t.Replace("'", "''") + "' " + "," + copB.comp_bank_branch + "='" + p.comp_bank_branch.Replace("'", "''") + "' " + "," + copB.comp_bank_active + "='" + p.comp_bank_active.Replace("'", "''") + "' " + "," + copB.acc_number + "='" + p.acc_number.Replace("'", "''") + "' " + "," + copB.remark + "='" + p.remark.Replace("'", "''") + "' " + "," + copB.date_modi + "=now() " + "," + copB.user_modi + "='" + userId + "' " + "," + copB.bank_id + "='" + p.bank_id + "' " + "Where " + copB.pkField + "='" + p.comp_bank_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String insert(CompanyBank p, String userId) { String re = "", sql = ""; p.active = "1"; chkNull(p); sql = "Insert Into " + copB.table + "(" + copB.comp_id + "," + copB.comp_bank_name_t + "," + copB.comp_bank_branch + "," + copB.comp_bank_active + "," + copB.acc_number + ", " + copB.remark + ", " + copB.date_create + "," + copB.date_modi + ", " + copB.date_cancel + ", " + copB.user_create + "," + copB.user_modi + ", " + copB.user_cancel + ", " + copB.active + "," + copB.bank_id + " " + ") " + "Values ('" + p.comp_id + "','" + p.comp_bank_name_t.Replace("'", "''") + "','" + p.comp_bank_branch.Replace("'", "''") + "'," + "'" + p.comp_bank_active.Replace("'", "''") + "','" + p.acc_number.Replace("'", "''") + "','" + p.remark.Replace("'", "''") + "'," + "now(),'" + p.date_modi + "','" + p.date_cancel + "'," + "'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," + "'" + p.active + "','" + p.bank_id + "' " + ")"; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public IHttpActionResult PostCompanyBank(CompanyBank companyBank) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CompanyBanks.Add(companyBank); try { db.SaveChanges(); } catch (DbUpdateException) { if (CompanyBankExists(companyBank.ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = companyBank.ID }, companyBank)); }
public IHttpActionResult PutCompanyBank(long id, CompanyBank companyBank) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != companyBank.ID) { return(BadRequest()); } db.Entry(companyBank).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CompanyBankExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public C1ComboBox setC1CboItem(C1ComboBox c) { lexpn.Clear(); ComboBoxItem item = new ComboBoxItem(); DataTable dt = selectAll(); //String aaa = ""; ComboBoxItem item1 = new ComboBoxItem(); item1.Text = ""; item1.Value = "000"; c.Items.Clear(); c.Items.Add(item1); //for (int i = 0; i < dt.Rows.Count; i++) foreach (DataRow row in dt.Rows) { item = new ComboBoxItem(); item.Text = row[copB.comp_bank_name_t].ToString() + " " + row[copB.comp_bank_branch].ToString() + " " + row[copB.acc_number].ToString(); item.Value = row[copB.comp_bank_id].ToString(); c.Items.Add(item); CompanyBank expn1 = new CompanyBank(); expn1.comp_bank_id = row[copB.comp_bank_id].ToString(); expn1.comp_bank_name_t = row[copB.comp_bank_name_t].ToString(); expn1.comp_bank_branch = row[copB.comp_bank_branch].ToString(); expn1.acc_number = row[copB.acc_number].ToString(); lexpn.Add(expn1); } return(c); }
public ActionResult DeleteConfirmed(int id) { CompanyBank companyBank = db.CompanyBank.Find(id); db.CompanyBank.Remove(companyBank); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetCompanyBank(long id) { CompanyBank companyBank = db.CompanyBanks.Find(id); if (companyBank == null) { return(NotFound()); } return(Ok(companyBank)); }
public ActionResult Edit([Bind(Include = "Id,CompanyId,BankId,AccountName,AccountNo,Branch,SwiftCode,RoutingNo,BranchCode,Address,InitialBalance")] CompanyBank companyBank) { if (ModelState.IsValid) { db.Entry(companyBank).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BankId = new SelectList(db.Bank, "Id", "Name", companyBank.BankId); ViewBag.CompanyId = new SelectList(db.Company, "Id", "Address", companyBank.CompanyId); return(View(companyBank)); }
public CompanyBank selectByPk1(String copId) { CompanyBank cop1 = new CompanyBank(); DataTable dt = new DataTable(); String sql = "select copB.* " + "From " + copB.table + " copB " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where copB." + copB.comp_id + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setCompany(dt); return(cop1); }
public IHttpActionResult DeleteCompanyBank(long id) { CompanyBank companyBank = db.CompanyBanks.Find(id); if (companyBank == null) { return(NotFound()); } db.CompanyBanks.Remove(companyBank); db.SaveChanges(); return(Ok(companyBank)); }
// GET: CompanyBanks/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyBank companyBank = db.CompanyBank.Find(id); if (companyBank == null) { return(HttpNotFound()); } return(View(companyBank)); }
public String insertCompany(CompanyBank p, String userId) { String re = ""; if (p.comp_bank_id.Equals("")) { re = insert(p, userId); } else { re = update(p, userId); } return(re); }
// GET: CompanyBanks/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyBank companyBank = db.CompanyBank.Find(id); if (companyBank == null) { return(HttpNotFound()); } ViewBag.BankId = new SelectList(db.Bank, "Id", "Name", companyBank.BankId); ViewBag.CompanyId = new SelectList(db.Company, "Id", "Address", companyBank.CompanyId); return(View(companyBank)); }
public List <CompanyBank> FillCompanyBankList(string companyId) { var banks = new List <CompanyBank>(); var i = 0; while (true) { var bankName = Request["group-bank[" + i + "][BankName]"]; var branchNameCode = Request["group-bank[" + i + "][BranchNameCode]"]; var accountNo = Request["group-bank[" + i + "][AccountNo]"]; var iban = Request["group-bank[" + i + "][Iban]"]; var swiftNo = Request["group-bank[" + i + "][SwiftNo]"]; var currencyType = Request["group-bank[" + i + "][CurrencyType]"]; var province = Request["group-bank[" + i + "][Province]"]; var district = Request["group-bank[" + i + "][District]"]; var bankId = Request["group-bank[" + i + "][BankId]"]; if (string.IsNullOrWhiteSpace(bankName) || string.IsNullOrWhiteSpace(branchNameCode) || string.IsNullOrWhiteSpace(accountNo) || string.IsNullOrWhiteSpace(currencyType)) { break; } var bank1 = new CompanyBank(); var temp = bankName.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); //bank1.BankNameTermName = temp[1]; var temp1 = branchNameCode.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); bank1.BranchCode = temp1[1].Trim(); bank1.BranchName = temp1[0].Trim(); bank1.AccountNo = accountNo; bank1.District = district; bank1.Province = province; bank1.Iban = iban; bank1.Id = bankId.AsInt(); bank1.BankNameTermId = int.Parse(temp[0]); bank1.SwiftNo = swiftNo; bank1.CompanyId = companyId; //bank1.EntityId = entityId; //bank1.EntityType = (int)entityType; var tempCurrencyTypeParts = currencyType.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); bank1.CurrencyTypeTermId = int.Parse(tempCurrencyTypeParts[0]); //bank1.CurrencyTypeTermName = tempCurrencyTypeParts[1]; //bank1.CreatedOn = DateTime.Now; banks.Add(bank1); i++; } return(banks); }
private CompanyBank setCompany(DataTable dt) { CompanyBank cop1 = new CompanyBank(); if (dt.Rows.Count > 0) { cop1.comp_bank_id = dt.Rows[0][copB.comp_bank_id].ToString(); cop1.comp_id = dt.Rows[0][copB.comp_id].ToString(); cop1.comp_bank_name_t = dt.Rows[0][copB.comp_bank_name_t].ToString(); cop1.comp_bank_branch = dt.Rows[0][copB.comp_bank_branch].ToString(); cop1.comp_bank_active = dt.Rows[0][copB.comp_bank_active].ToString(); cop1.acc_number = dt.Rows[0][copB.acc_number].ToString(); cop1.remark = dt.Rows[0][copB.remark].ToString(); cop1.date_create = dt.Rows[0][copB.date_create].ToString(); cop1.date_modi = dt.Rows[0][copB.date_modi].ToString(); cop1.date_cancel = dt.Rows[0][copB.date_cancel].ToString(); cop1.user_create = dt.Rows[0][copB.user_create].ToString(); cop1.user_modi = dt.Rows[0][copB.user_modi].ToString(); cop1.user_cancel = dt.Rows[0][copB.user_cancel].ToString(); cop1.active = dt.Rows[0][copB.active].ToString(); cop1.bank_id = dt.Rows[0][copB.bank_id].ToString(); } else { cop1.comp_bank_id = ""; cop1.comp_id = ""; cop1.comp_bank_name_t = ""; cop1.comp_bank_branch = ""; cop1.comp_bank_active = ""; cop1.acc_number = ""; cop1.remark = ""; cop1.date_create = ""; cop1.date_modi = ""; cop1.date_cancel = ""; cop1.user_create = ""; cop1.user_modi = ""; cop1.user_cancel = ""; cop1.active = ""; cop1.bank_id = ""; } return(cop1); }
private void chkNull(CompanyBank p) { int chk = 0; Decimal chk1 = 0; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.comp_id = p.comp_id == null ? "" : p.comp_id; p.comp_bank_name_t = p.comp_bank_name_t == null ? "" : p.comp_bank_name_t; p.comp_bank_active = p.comp_bank_active == null ? "" : p.comp_bank_active; p.acc_number = p.acc_number == null ? "" : p.acc_number; p.remark = p.remark == null ? "" : p.remark; p.active = p.active == null ? "" : p.active; //p.bank_id = p.bank_id == null ? "" : p.bank_id; //p.inv_line2 = p.inv_line2 == null ? "" : p.inv_line2; //p.inv_line4 = p.inv_line4 == null ? "" : p.inv_line4; p.bank_id = int.TryParse(p.bank_id, out chk) ? chk1.ToString() : "0"; }
private void initConfig() { copB = new CompanyBank(); copB.comp_bank_id = "comp_bank_id"; copB.comp_id = "comp_id"; copB.comp_bank_name_t = "comp_bank_name_t"; copB.comp_bank_branch = "comp_bank_branch"; copB.comp_bank_active = "comp_bank_active"; copB.acc_number = "acc_number"; copB.remark = "remark"; copB.date_create = "date_create"; copB.date_modi = "date_modi"; copB.date_cancel = "date_cancel"; copB.user_create = "user_create"; copB.user_modi = "user_modi"; copB.user_cancel = "user_cancel"; copB.active = "active"; copB.bank_id = "bank_id"; copB.table = "b_company_bank"; copB.pkField = "comp_bank_id"; lexpn = new List <CompanyBank>(); }