public ResponseData AddPerson([FromBody] ZL_PersonSetup person)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
ResponseData response = new ResponseData();
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlTransaction tran = con.BeginTransaction();
BllZL_PersonSetup bll = new BllZL_PersonSetup(con);
if (bll.AddPerson(person, tran))
{
tran.Commit();
response.result = true;
response.msg = "Ìí¼Ó³É¹¦";
}
else
{
response.result = false;
response.msg = "Ìí¼Óʧ°Ü";
}
}
catch (Exception ex)
{
response.result = false;
response.msg = ex.Message;
}
return(response);
}
}
public bool UpdatePerson(ZL_PersonSetup person, SqlTransaction tran)
{
string strsql = @"update ZL_PersonSetup set EmployeeNo=@EmployeeNo ,EmployeeName=@EmployeeName,WorkProduct=@WorkProduct,
WorkName=@WorkName where PersonAutoID=@PersonAutoID";
if (_con.Execute(strsql, person, tran) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddPerson(ZL_PersonSetup person, SqlTransaction tran)
{
string strsql = @"insert into ZL_PersonSetup(EmployeeNo,EmployeeName,WorkProduct,WorkName)
values(@EmployeeNo,@EmployeeName,@WorkProduct,@WorkName)";
if (_con.Execute(strsql, person, tran) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdatePerson(ZL_PersonSetup person, SqlTransaction tran)
{
return(_con.UpdatePerson(person, tran));
}
public bool AddPerson(ZL_PersonSetup person, SqlTransaction tran)
{
return(_con.AddPerson(person, tran));
}
