/// <summary>
///[FactLinkman]表查询实体的方法
/// </summary>
public static FactLinkman getFactLinkmanById(int id)
{
FactLinkman factlinkman = null;
string sql = "select * from FactLinkman where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
factlinkman = new FactLinkman();
foreach (DataRow dr in dt.Rows)
{
factlinkman.Id = Convert.ToInt32(dr["id"]);
factlinkman.FactId = Convert.ToInt32(dr["factId"]);
factlinkman.LinkName = Convert.ToString(dr["linkName"]);
factlinkman.Duty = Convert.ToString(dr["duty"]);
factlinkman.Telephone = Convert.ToString(dr["telephone"]);
factlinkman.Fax = Convert.ToString(dr["fax"]);
factlinkman.Mobile = Convert.ToString(dr["mobile"]);
factlinkman.Email = Convert.ToString(dr["email"]);
factlinkman.QQ = Convert.ToString(dr["QQ"]);
factlinkman.Skype = Convert.ToString(dr["skype"]);
}
}
return(factlinkman);
}
/// <summary>
/// 加载联系人信息
/// </summary>
private void loadLink()
{
string witch = Request.QueryString["witch"]; //用于判断是查看收款单位还是付款单位的联系人
string linkId = Request.QueryString["linkid"]; //联系人id
string payid = Request.QueryString["payid"]; //付款单位id
if (linkId == "0")
{
Factory model = FactoryManager.getFactoryById(int.Parse(payid));
linkName.Value = model.LinkeName; //联系人名称
linkPost.Value = model.Duty; //职位
linkMobile.Value = model.Mobile; //手机号码
linkTel.Value = model.Telephone; //联系电话
linkFax.Value = model.Fax; //联系传真
linkEmail.Value = model.Email; //邮箱地址
linkMsn.Value = model.QQ; //qq
linkSkype.Value = model.Skype; //skype
}
else
{
FactLinkman model = FactLinkmanManager.getFactLinkmanById(int.Parse(linkId));
linkName.Value = model.LinkName; //联系人名称
linkPost.Value = model.Duty; //职位
linkMobile.Value = model.Mobile; //手机号码
linkTel.Value = model.Telephone; //联系电话
linkFax.Value = model.Fax; //联系传真
linkEmail.Value = model.Email; //邮箱地址
linkMsn.Value = model.QQ; //qq
linkSkype.Value = model.Skype; //skype
}
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <FactLinkman> getFactLinkmansBySql(string sql)
{
IList <FactLinkman> list = new List <FactLinkman>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
FactLinkman factlinkman = new FactLinkman();
factlinkman.Id = Convert.ToInt32(dr["id"]);
factlinkman.FactId = Convert.ToInt32(dr["factId"]);
factlinkman.LinkName = Convert.ToString(dr["linkName"]);
factlinkman.Duty = Convert.ToString(dr["duty"]);
factlinkman.Telephone = Convert.ToString(dr["telephone"]);
factlinkman.Fax = Convert.ToString(dr["fax"]);
factlinkman.Mobile = Convert.ToString(dr["mobile"]);
factlinkman.Email = Convert.ToString(dr["email"]);
factlinkman.QQ = Convert.ToString(dr["QQ"]);
factlinkman.Skype = Convert.ToString(dr["skype"]);
list.Add(factlinkman);
}
}
return(list);
}
/// <summary>
///[FactLinkman]表添加的方法
/// </summary>
public static int addFactLinkman(FactLinkman factlinkman)
{
string sql = "insert into FactLinkman([factId],[linkName],[duty],[telephone],[fax],[mobile],[email],[QQ],[skype]) values (@factId,@linkName,@duty,@telephone,@fax,@mobile,@email,@QQ,@skype)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@factId", factlinkman.FactId),
new SqlParameter("@linkName", factlinkman.LinkName),
new SqlParameter("@duty", factlinkman.Duty),
new SqlParameter("@telephone", factlinkman.Telephone),
new SqlParameter("@fax", factlinkman.Fax),
new SqlParameter("@mobile", factlinkman.Mobile),
new SqlParameter("@email", factlinkman.Email),
new SqlParameter("@QQ", factlinkman.QQ),
new SqlParameter("@skype", factlinkman.Skype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[FactLinkman]表修改的方法
/// </summary>
public static int updateFactLinkmanById(FactLinkman factlinkman)
{
string sql = "update FactLinkman set factId=@factId,linkName=@linkName,duty=@duty,telephone=@telephone,fax=@fax,mobile=@mobile,email=@email,QQ=@QQ,skype=@skype where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", factlinkman.Id),
new SqlParameter("@factId", factlinkman.FactId),
new SqlParameter("@linkName", factlinkman.LinkName),
new SqlParameter("@duty", factlinkman.Duty),
new SqlParameter("@telephone", factlinkman.Telephone),
new SqlParameter("@fax", factlinkman.Fax),
new SqlParameter("@mobile", factlinkman.Mobile),
new SqlParameter("@email", factlinkman.Email),
new SqlParameter("@QQ", factlinkman.QQ),
new SqlParameter("@skype", factlinkman.Skype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
public static int updateFactLinkman(FactLinkman factlinkman)
{
return(FactLinkmanService.updateFactLinkmanById(factlinkman));
}
public static int addFactLinkman(FactLinkman factlinkman)
{
return(FactLinkmanService.addFactLinkman(factlinkman));
}
