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);
}
