private void companySaveBtn_Click(object sender, EventArgs e) { count = 0; CompanyAdd aCompany = new CompanyAdd(); aCompany.CompanyName = companyTextBox.Text; companyTextBox.Text = ""; companyTextBox.Clear(); companyTextBox.Focus(); if (companySaveBtn.Text == "Save") { string message = aCompanyManager.SaveCompany(aCompany); MessageBox.Show(message); } else { aCompany.Id = Convert.ToInt32(hiddenIdLevel.Text); string message = aCompanyManager.UpdateCompany(aCompany); MessageBox.Show(message); } PopulateCompanyListView(); }
private void ItemEntryUI_Load(object sender, EventArgs e) { //Product CategoryAdd defaultCategory = new CategoryAdd(); defaultCategory.Id = -1; defaultCategory.Category = "--Select--"; List <CategoryAdd> categories = aCategoryManager.GetAllCategory(); categories.Insert(0, defaultCategory); itemCategoryComboBox.DataSource = categories; itemCategoryComboBox.DisplayMember = "Category"; itemCategoryComboBox.ValueMember = "Id"; // Company CompanyAdd defaultCompany = new CompanyAdd(); defaultCompany.Id = -1; defaultCompany.CompanyName = "--Select--"; List <CompanyAdd> companies = aCompanyManager.GetAllCompanies(); companies.Insert(0, defaultCompany); itemCompanyNameComboBox.DataSource = companies; itemCompanyNameComboBox.DisplayMember = "CompanyName"; itemCompanyNameComboBox.ValueMember = "Id"; }
public List <CompanyAdd> GetAllCompanies() { connection = new SqlConnection(); connection.ConnectionString = connectionString; cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM Company"; cmd.Connection = connection; connection.Open(); reader = cmd.ExecuteReader(); List <CompanyAdd> companies = new List <CompanyAdd>(); while (reader.Read()) { CompanyAdd company = new CompanyAdd(); company.Id = (int)reader["Id"]; company.CompanyName = reader["CompanyName"].ToString(); companies.Add(company); } reader.Close(); connection.Close(); return(companies); }
public string UpdateCompany(CompanyAdd company) { int rowaffected = aCompanyGateway.UpdateCompany(company); if (rowaffected > 0) { return("Update successfully."); } return("Update failed."); }
public async Task <ActionResult <ReturnResponse <Company> > > AddCompany(CompanyAdd inVal) { try { return(await _service.Add(inVal)); } catch (Exception ex) { return(NotFound(ex.Message)); } }
private void StockOut_Load(object sender, EventArgs e) { CompanyAdd defaultCompany = new CompanyAdd(); defaultCompany.Id = -1; defaultCompany.CompanyName = "--Select--"; List <CompanyAdd> companies = aItemManager.GetAllCompanies(); companies.Insert(0, defaultCompany); companyOutComboBox.DataSource = companies; companyOutComboBox.DisplayMember = "CompanyName"; }
private void companyListView_DoubleClick(object sender, EventArgs e) { ListViewItem selectedItem = companyListView.SelectedItems[0]; CompanyAdd company = selectedItem.Tag as CompanyAdd; if (company != null) { companyTextBox.Text = company.CompanyName; hiddenIdLevel.Text = company.Id.ToString(); companySaveBtn.Text = "Update"; } }
public string SaveCompany(CompanyAdd aCompany) { if (aCompanyGateway.IsNameExist(aCompany.CompanyName)) { return("Company Name Already Exists."); } int rowaffected = aCompanyGateway.SaveCompany(aCompany); if (rowaffected > 0) { return("Save Successfully."); } return("Save Failed."); }
public ActionResult Edit(CompanyEdit model) { //日期格式转换成Unix时间戳格式。 if (!string.IsNullOrEmpty(model.setDate)) { model.setDate = DateTimeHelper.ConvertDateTimeInt(model.setDate.ToDateTime()).ToString(); } if (model.id > 0) { //修改 Entity.ResultEntity updateResult = _cServices.UpdateCompany(model); ShowMessageHelper.MessageBoxBackPage("单位信息修改成功"); } else { //新建 CompanyAdd entity = new CompanyAdd() { unitName = model.unitName, address = model.address, clientId = model.clientId, cop = model.cop, fax = model.fax, tel1 = model.tel1, tel2 = model.tel2, typeId = model.typeId, gradeSid = model.gradeSid, linkman = model.linkman, notused = model.notused, remark = model.remark, setDate = model.setDate, setMan = model.setMan }; ResultAddCompany addResult = _cServices.AddCompany(entity); if (addResult != null && addResult.result == "1") { model.id = addResult.id; model.unitId = addResult.unitId; ShowMessageHelper.MessageBoxBackPage("单位信息创建成功"); } else { ShowMessageHelper.MessageBoxBackPage("服务器异常,请稍后再试"); } } LoadDropDownListData(); return(View(model)); }
public int UpdateCompany(CompanyAdd aCompany) { query = "UPDATE Company SET CompanyName = @CompanyName WHERE Id = @Id"; cmd = new SqlCommand(query, connection); cmd.Parameters.Clear(); cmd.Parameters.Add("CompanyName", SqlDbType.NVarChar); cmd.Parameters["CompanyName"].Value = aCompany.CompanyName; cmd.Parameters.Add("Id", SqlDbType.Int); cmd.Parameters["Id"].Value = aCompany.Id; connection.Open(); int rowAffected = cmd.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public int SaveCompany(CompanyAdd aCompany) { connection = new SqlConnection(connectionString); connection.Open(); query = "INSERT INTO Company (CompanyName) VALUES (@CompanyName)"; cmd = new SqlCommand(query, connection); cmd.Parameters.Clear(); cmd.Parameters.Add("CompanyName", SqlDbType.NVarChar); cmd.Parameters["CompanyName"].Value = aCompany.CompanyName; //cmd.Parameters.AddWithValue("CompanyName", aCompany.CompanyName); int rowAffected = cmd.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
/// <summary> /// 创建新企业单位 /// </summary> /// <param name="entity">接口参数实体对象</param> /// <returns></returns> public ResultAddCompany AddCompany(CompanyAdd entity) { ResultAddCompany result = CallAPIHelper.CallAPIInPOST <ResultAddCompany>(APIAddressSetting.API_POST_ADDUnit, entity); return(result); }