/// <summary>
///[CusLinkman]表查询实体的方法
/// </summary>
public static CusLinkman getCusLinkmanById(int id)
{
CusLinkman cuslinkman = null;
string sql = "select * from CusLinkman where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
cuslinkman = new CusLinkman();
foreach (DataRow dr in dt.Rows)
{
cuslinkman.Id = Convert.ToInt32(dr["id"]);
cuslinkman.CustomerId = Convert.ToInt32(dr["customerId"]);
cuslinkman.LinkName = Convert.ToString(dr["linkName"]);
cuslinkman.DepartName = Convert.ToString(dr["departName"]);
cuslinkman.Telephone = Convert.ToString(dr["telephone"]);
cuslinkman.Fax = Convert.ToString(dr["fax"]);
cuslinkman.Mobile = Convert.ToString(dr["mobile"]);
cuslinkman.Email = Convert.ToString(dr["email"]);
cuslinkman.Msn = Convert.ToString(dr["msn"]);
cuslinkman.Skype = Convert.ToString(dr["skype"]);
}
}
return(cuslinkman);
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <CusLinkman> getCusLinkmansBySql(string sql)
{
IList <CusLinkman> list = new List <CusLinkman>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
CusLinkman cuslinkman = new CusLinkman();
cuslinkman.Id = Convert.ToInt32(dr["id"]);
cuslinkman.CustomerId = Convert.ToInt32(dr["customerId"]);
cuslinkman.LinkName = Convert.ToString(dr["linkName"]);
cuslinkman.DepartName = Convert.ToString(dr["departName"]);
cuslinkman.Telephone = Convert.ToString(dr["telephone"]);
cuslinkman.Fax = Convert.ToString(dr["fax"]);
cuslinkman.Mobile = Convert.ToString(dr["mobile"]);
cuslinkman.Email = Convert.ToString(dr["email"]);
cuslinkman.Msn = Convert.ToString(dr["msn"]);
cuslinkman.Skype = Convert.ToString(dr["skype"]);
list.Add(cuslinkman);
}
}
return(list);
}
/// <summary>
/// 加载营业部信息
/// </summary>
private void loadDepart()
{
string departid = Request.QueryString["departid"]; //营业部id
CusLinkman model = CusLinkmanManager.getCusLinkmanById(int.Parse(departid));
departName.Value = model.DepartName; //营业部名称
linkTel.Value = model.Telephone; //电话
linkFax.Value = model.Fax; //传真
linkEmail.Value = model.Email; //邮箱
linkMsn.Value = model.Msn; //qq
linkSkype.Value = model.Skype; //skype
}
private void addlinkinfo()
{
//联系人信息
EtNet_Models.CusLinkman cusLink = new CusLinkman();
cusLink.CustomerId = CustomerManager.getLastOneID().Id;
cusLink.LinkName = this.linkname.Value.ToString();
cusLink.Post = this.linkpost.Value.ToString();
cusLink.Telephone = this.linktel.Value.ToString();
cusLink.Fax = this.linkfax.Value.ToString();
cusLink.Email = this.linkemail.Value.ToString();
cusLink.Mobile = this.linkmobile.Value.ToString();
cusLink.Msn = this.linkmsn.Value.ToString();
cusLink.Skype = this.linkskype.Value.ToString();
CusLinkmanManager.addCusLinkman(cusLink);
}
/// <summary>
///[CusLinkman]表添加的方法
/// </summary>
public static int addCusLinkman(CusLinkman cuslinkman)
{
string sql = "insert into CusLinkman([customerId],[linkName],[departName],[telephone],[fax],[mobile],[email],[msn],[skype]) values (@customerId,@linkName,@departName,@telephone,@fax,@mobile,@email,@msn,@skype)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@customerId", cuslinkman.CustomerId),
new SqlParameter("@linkName", cuslinkman.LinkName),
new SqlParameter("@departName", cuslinkman.DepartName),
new SqlParameter("@telephone", cuslinkman.Telephone),
new SqlParameter("@fax", cuslinkman.Fax),
new SqlParameter("@mobile", cuslinkman.Mobile),
new SqlParameter("@email", cuslinkman.Email),
new SqlParameter("@msn", cuslinkman.Msn),
new SqlParameter("@skype", cuslinkman.Skype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[CusLinkman]表修改的方法
/// </summary>
public static int updateCusLinkmanById(CusLinkman cuslinkman)
{
string sql = "update CusLinkman set customerId=@customerId,linkName=@linkName,departName=@departName,telephone=@telephone,fax=@fax,mobile=@mobile,email=@email,msn=@msn,skype=@skype where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", cuslinkman.Id),
new SqlParameter("@customerId", cuslinkman.CustomerId),
new SqlParameter("@linkName", cuslinkman.LinkName),
new SqlParameter("@departName", cuslinkman.DepartName),
new SqlParameter("@telephone", cuslinkman.Telephone),
new SqlParameter("@fax", cuslinkman.Fax),
new SqlParameter("@mobile", cuslinkman.Mobile),
new SqlParameter("@email", cuslinkman.Email),
new SqlParameter("@msn", cuslinkman.Msn),
new SqlParameter("@skype", cuslinkman.Skype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
public static int updateCusLinkman(CusLinkman cuslinkman)
{
return(CusLinkmanService.updateCusLinkmanById(cuslinkman));
}
public static int addCusLinkman(CusLinkman cuslinkman)
{
return(CusLinkmanService.addCusLinkman(cuslinkman));
}
