public void DelLiaisonanMan()
{
LiaisonanMan lman = new LiaisonanMan();
var Id = int.Parse(_request.Form["Userid"].ToString());
lman.Id = Id;
_response.Write(_bi.DelLiaisonanMan(lman));
}
public bool DelLiaisonanMan(LiaisonanMan lman)
{
var sql = "Update LiaisonanMan set IsDeleteed = 1 where ID = @Id";
var sid = DBHelper.Execute(sql,
new SqlParameter("@Id", lman.Id));
if (sid > 0)
{
return(true);
}
else
{
return(false);
}
}
public void AddLiaisonanMan()
{
LiaisonanMan lman = new LiaisonanMan();
var data = _request;
var LiaisonanManName = data.Form["LiaisonanManName"].ToString();
var LiaisonanManPost = data.Form["LiaisonanManPost"].ToString();
var LiaisonanManPhone = data.Form["LiaisonanManPhone"].ToString();
var LiaisonanManBankId = data.Form["LiaisonanManBankId"].ToString();
lman.Name = LiaisonanManName;
lman.Post = LiaisonanManPost;
lman.Phone = LiaisonanManPhone;
lman.BankId = int.Parse(LiaisonanManBankId);
_response.Write(_bi.AddLiaisonanMan(lman));
}
public bool EditLiaisonanMan(LiaisonanMan lman)
{
var sql = "update LiaisonanMan set Name = @Name,Post= @Post,Phone=@Phone where ID = @Id";
var sid = DBHelper.Execute(sql,
new SqlParameter("@Id", lman.Id),
new SqlParameter("@Name", lman.Name),
new SqlParameter("@Post", lman.Post),
new SqlParameter("@Phone", lman.Phone));
if (sid > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddLiaisonanMan(LiaisonanMan lman)
{
string sql = "insert into LiaisonanMan (BankId,Name,Post,Phone)values(@BankId,@Name,@Post,@Phone)";
var sid = DBHelper.Execute(sql,
new SqlParameter("@BankId", lman.BankId),
new SqlParameter("@Name", lman.Name),
new SqlParameter("@Post", lman.Post),
new SqlParameter("@Phone", lman.Phone));
if (sid > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool DelLiaisonanMan(LiaisonanMan lman)
{
return(bi.DelLiaisonanMan(lman));
}
public bool EditLiaisonanMan(LiaisonanMan lman)
{
return(bi.EditLiaisonanMan(lman));
}
public bool AddLiaisonanMan(LiaisonanMan lman)
{
return(bi.AddLiaisonanMan(lman));
}
