private void button8_Click(object sender, EventArgs e)
{
try
{
CustomerMember cus = new CustomerMember();
cus.Id = t编号.Text;
cus.Name = t姓名.Text;
cus.Type = t类型.Text;
cus.Phone = t电话.Text;
cus.Email = t电子邮件.Text;
cus.CustomerId = t所属客户.Text;
if (this.userMgr.UpdateCustomerMember(cus))
{
MessageBox.Show("客户联系人[" + t编号.Text + "]修改成功！");
//更新表格数据
dataGridView2.DataSource = this.userMgr.GetCustomerMembersByCustomer(selectedCustomerId);
dataGridView2.Update();
}
else
{
MessageBox.Show("修改失败！");
}
}
catch (Exception ex) { }
}
public CustomerInfo(Member member, BasicForm form)
{
InitializeComponent();
_LoginInfo = member;
_Mother = form;
_CustomerController = new CustomerController();
_SelectData = new Customer();
_SelectData_m = new CustomerMember();
cb_customer_Select.SelectedIndex = 1;
btn_member_add.Enabled = false;
btn_member_modify.Enabled = false;
btn_member_delete.Enabled = false;
GetDgvCompany();
_SelectData.No = (int)dgv_company.Rows[0].Cells[0].Value;
_SelectData.CGroup = dgv_company.Rows[0].Cells[1].Value.ToString();
_SelectData.Name = dgv_company.Rows[0].Cells[2].Value.ToString();
_SelectData.CEO = dgv_company.Rows[0].Cells[3].Value.ToString();
_SelectData.Address = dgv_company.Rows[0].Cells[4].Value.ToString();
_SelectData.Number = dgv_company.Rows[0].Cells[5].Value.ToString();
_SelectData.Fax = dgv_company.Rows[0].Cells[6].Value.ToString();
_SelectData.Transaction = dgv_company.Rows[0].Cells[7].Value.ToString();
SetUpdata(_SelectData);
CompanyComboboxListAdd();
}
public ActionResult Create(Customer customer)
{
//check if object is valid based on dataanotaion
if (!ModelState.IsValid)
{
var viewmodel = new CustomerMember
{
Customer = customer,
MembershipType = _context.MembershipTypes.ToList()
};
return(View("New", viewmodel));
}
if (customer.Id == 0)
{
_context.Customers.Add(customer);
}
else
{
var UpdateDB = _context.Customers.Single(c => c.Id == customer.Id);
UpdateDB.Name = customer.Name;
UpdateDB.BirthDate = customer.BirthDate;
UpdateDB.IsSubscribedToNewLetter = customer.IsSubscribedToNewLetter;
UpdateDB.MembershipTypeId = customer.MembershipTypeId;
}
_context.SaveChanges();
return(RedirectToAction("Index", "Customers"));
}
public static bool ModifyCustomerMember(CustomerMember model)
{
string sql = string.Format(@"update {0} set [CompanyId]=@CompanyId,
[CompanyName]=@CompanyName,[CusCompanyId]=@CusCompanyId,[Name]=@Name,[ImgUrl]=@ImgUrl,[Mobile]=@Mobile,[Email]=@Email,[Infos]=@Infos,
[IsDeleted]=@IsDeleted,[ModifyDate]=getdate(),[ModifyBy]=@ModifyBy,[Job]=@Job,[Sex]=@Sex
where Id=@Id", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
private void SetUpdataMember(CustomerMember customermember)
{
cb_member_code.Text = customermember.No.ToString();
txt_member_name.Text = customermember.Name;
txt_member_part.Text = customermember.Part;
txt_member_position.Text = customermember.Rank;
txt_member_number.Text = customermember.Number;
txt_member_fax.Text = customermember.Fax;
txt_member_email.Text = customermember.Email;
txt_member_etc.Text = customermember.ETC;
}
public ActionResult New()
{
var membership = _context.MembershipTypes.ToList();
var CusMem = new CustomerMember
{
Customer = new Customer(),
MembershipType = membership
};
return(View(CusMem));
}
public bool AltCustomerMember(CustomerMember cus)
{
try
{
string sql = "UPDATE qiaotai.客户联系人 SET 编号='" + cus.Id + "',姓名='" + cus.Name + "',类型='" + cus.Type + "',联系电话='" + cus.Phone + "',电子邮件='" + cus.Email + "',所属客户编号='" + cus.CustomerId + "' WHERE 编号='" + cus.Id + "';";
MySqlCommand cmd = new MySqlCommand(sql, this.Connection);
this.Connection.Open();
cmd.ExecuteNonQuery();
this.Connection.Close();
return(true);
}
catch (Exception ex) { this.Connection.Close(); throw ex; }
}
public bool AddNewCustomerMember(CustomerMember cus)
{
try
{
string sql = "INSERT INTO qiaotai.客户联系人(姓名,类型,联系电话,电子邮件,所属客户编号) VALUES ('" + cus.Name + "','" + cus.Type + "','" + cus.Phone + "','" + cus.Email + "','" + cus.CustomerId + "')";
MySqlCommand cmd = new MySqlCommand(sql, this.Connection);
this.Connection.Open();
cmd.ExecuteNonQuery();
this.Connection.Close();
return(true);
}
catch (Exception ex) { this.Connection.Close(); throw ex; }
}
private void com客户联系人_DropDown(object sender, EventArgs e)
{
CustomerMember[] result = new CustomerMember[] { };
com客户联系人.Items.Clear();
if (selectedCustomerId != "")
{
cMembers = userMgr.GetCustomerMembersByCId(selectedCustomerId);
result = cMembers.ToArray();
}
com客户联系人.Items.AddRange(result);
com客户联系人.DisplayMember = "Name";
com客户联系人.ValueMember = "Id";
}
public CustomerInfo(Member member, BasicForm form)
{
InitializeComponent();
_LoginInfo = member;
_Mother = form;
_CustomerController = new CustomerController();
_SelectData = new Customer();
_SelectData_m = new CustomerMember();
cb_customer_Select.SelectedIndex = 1;
GetDgvCompany();
}
public ActionResult Edit(int id)
{
var customer = _context.Customers.SingleOrDefault(c => c.Id == id);
if (customer == null)
{
return(HttpNotFound());
}
var viewmodel = new CustomerMember
{
Customer = customer,
MembershipType = _context.MembershipTypes.ToList()
};
return(View("New", viewmodel));
}
public static bool AddAccount(CustomerCompany company, CustomerMember member, Account account, ProjectManage projectManage, HardWare hardWare, List <PersonSetting> personSettings)
{
string companySql = string.Format("insert into {0}([CompanyId],[CompanyName],[Name],[City],[Address],[Status],[Infos],[IsDeleted],[CreateDate],[CreateBy],[TeamDesc],[CompanyStatus],[PartInfo]) " +
"values(@CompanyId,@CompanyName,@Name,@City,@Address,@Status,@Infos,0,getdate(),@CreateBy,@TeamDesc,@CompanyStatus,@PartInfo);SELECT @@IDENTITY ",
CompanyTableName);
string memberSql = string.Format("insert into {0}([CompanyId],[CompanyName],[CusCompanyId],[Name],[ImgUrl],[Mobile],[Email],[Infos],[IsDeleted],[CreateDate],[CreateBy]) " +
" values(@CompanyId,@CompanyName,@CusCompanyId,@Name,@ImgUrl,@Mobile,@Email,@Infos,0,getdate(),@CreateBy);SELECT @@IDENTITY", MemberTableName);
string sql = string.Format("insert into {0}([Mobile],[Email],[Password],[IsDeleted],[CreateDate],[CreateBy],[Role],[AccountName],[AccountId]) values" +
"(@Mobile,@Email,@Password,0,getdate(),@CreateBy,@Role,@AccountName,@AccountId);SELECT @@IDENTITY", TableName);
string Projectsql = string.Format("insert into {0}([Name],[FullName],[PayWay],[Money],[Status],[Infos],[CompanyId],[CreateDate],[CreateBy],[IsDeleted]," +
"[CusMemberId],[CusCompanyId],[Source],[OpereateType],[DevType],[NowStatus],[DevLanguate],[MarketProspect],[Month])" +
" values(@Name,@FullName,@PayWay,@Money,@Status,@Infos,@CompanyId,getdate(),@CreateBy,0,@CusMemberId,@CusCompanyId,@Source,@OpereateType,@DevType,@NowStatus,@DevLanguate,@MarketProspect,@Month);SELECT @@IDENTITY", ProjectTableName);
string HardWareSql = string.Format("insert into {0}([IsDeleted],[CreateDate],[CreateBy],[WorkGuid],[Infos],[ProjectId]) values(0,getdate(),@CreateBy,@WorkGuid,@Infos,@ProjectId)", HardWareTableName);
string PersonSettingSql = string.Format("insert into {0}([IsDeleted],[CreateDate],[CreateBy],[WorkGuid],[Price],[DepartId],[DepartName],[Infos],[Month],[TotalPrice],[Discount],[ProjectId]) values(0,getdate(),@CreateBy,@WorkGuid,@Price,@DepartId,@DepartName,@Infos,@Month,@TotalPrice,@Discount,@ProjectId)", PersonSettingTableName);
using (SqlConnection con = new SqlConnection(ConfigSetting.DataConnection))
{
con.Open();
var companyId = con.Query <int>(companySql, company).FirstOrDefault();
member.CusCompanyId = companyId;
var memberId = con.Query <int>(memberSql, member).FirstOrDefault();
account.AccountId = memberId;
var accountId = con.Query <int>(sql, account).FirstOrDefault();
projectManage.CusCompanyId = companyId;
projectManage.CusMemberId = memberId;
projectManage.CreateBy = account.AccountName;
if (personSettings != null && personSettings.Count() > 0)
{
projectManage.Money = personSettings.Sum(a => a.TotalPrice);
}
var projectId = con.Query <int>(Projectsql, projectManage).FirstOrDefault();
hardWare.ProjectId = projectId;
personSettings.ForEach(a => { a.ProjectId = projectId; });
if (personSettings != null && personSettings.Count() > 0)
{
con.Execute(PersonSettingSql, personSettings);
}
return(con.Execute(HardWareSql, hardWare) > 0);
}
return(true);
//string sql = string.Format("insert into {0}([Mobile],[Email],[Password],[IsDeleted],[CreateDate],[CreateBy],[Role],[AccountName]) values(@Mobile,@Email,@Password,0,getdate(),@CreateBy,@Role,@AccountName)", TableName);
//return DBAccess.ExecuteSqlWithEntity(sql, model);
}
public JsonResult SaveMemberInfo(CustomerMember member)
{
var info = new ResultInfo();
var account = CookieOperate.AccountCookie;
var id = account.AccountId;
var data = CustomerMemberDBOperate.GetModelById(id);
if (member.Sex != "")
{
data.Sex = member.Sex;
}
if (member.Name != "")
{
data.Name = member.Name; account.AccountName = member.Name;
}
if (member.Job != "")
{
data.Job = member.Job;
}
if (member.Email != "")
{
data.Email = member.Email; account.Email = member.Email;
}
if (member.Mobile != "")
{
data.Mobile = member.Mobile; account.Mobile = member.Mobile;
}
info.IsSuccess = CustomerMemberDBOperate.ModifyCustomerMember(data);
AccountDBOperate.ModifyAccount(account);
if (info.IsSuccess)
{
info.Message = "修改成功";
}
else
{
info.Message = "修改失败";
}
return(Json(info));
}
public static bool AddAccount(CustomerCompany company, CustomerMember member, Account account)
{
string companySql = string.Format("insert into {0}([CompanyId],[CompanyName],[Name],[City],[Address],[Status],[Infos],[IsDeleted],[CreateDate],[CreateBy]) " +
"values(@CompanyId,@CompanyName,@Name,@City,@Address,@Status,@Infos,0,getdate(),@CreateBy);SELECT @@IDENTITY ",
CompanyTableName);
string memberSql = string.Format("insert into {0}([CompanyId],[CompanyName],[CusCompanyId],[Name],[ImgUrl],[Mobile],[Email],[Infos],[IsDeleted],[CreateDate],[CreateBy]) " +
" values(@CompanyId,@CompanyName,@CusCompanyId,@Name,@ImgUrl,@Mobile,@Email,@Infos,0,getdate(),@CreateBy);SELECT @@IDENTITY", MemberTableName);
string sql = string.Format("insert into {0}([Mobile],[Email],[Password],[IsDeleted],[CreateDate],[CreateBy],[Role],[AccountName],[AccountId]) values" +
"(@Mobile,@Email,@Password,0,getdate(),@CreateBy,@Role,@AccountName,@AccountId)", TableName);
using (SqlConnection con = new SqlConnection(ConfigSetting.DataConnection))
{
con.Open();
var companyId = con.Query <int>(companySql, company).FirstOrDefault();
member.CusCompanyId = companyId;
var memberId = con.Query <int>(memberSql, member).FirstOrDefault();
account.AccountId = memberId;
return(con.Execute(sql, account) > 0);
}
return(true);
//string sql = string.Format("insert into {0}([Mobile],[Email],[Password],[IsDeleted],[CreateDate],[CreateBy],[Role],[AccountName]) values(@Mobile,@Email,@Password,0,getdate(),@CreateBy,@Role,@AccountName)", TableName);
//return DBAccess.ExecuteSqlWithEntity(sql, model);
}
public void AddCustomerMemberData(CustomerMember selectData)
{
dataBase.AddCustomerMemberData(selectData);
}
public static bool AddCustomerMember(CustomerMember model)
{
string sql = string.Format("insert into {0}([CompanyId],[CompanyName],[CusCompanyId],[Name],[ImgUrl],[Mobile],[Email],[Infos],[IsDeleted],[CreateDate],[CreateBy],[Source]) values(@CompanyId,@CompanyName,@CusCompanyId,@Name,@ImgUrl,@Mobile,@Email,@Infos,0,getdate(),@CreateBy,@Source)", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
public void AddCustomerMember(CustomerMember cm)
{
dataBase.AddCustomerMember(cm);
_form.SetAlarm("업체 담당자 추가가 완료되었습니다.");
_form.ResultOk();
}
public void DeleteCustomerMemberData(CustomerMember selectData)
{
dataBase.DeleteCustomerMemberData(selectData);
}
public void ModifyCustomerMemberData(CustomerMember selectData)
{
dataBase.ModifyCustomerMemberData(selectData);
}
