public static bool ModifyBG_PayProject(BG_PayProject bG_PayProject)
{
string sql =
"UPDATE BG_PayProject " +
"SET " +
"PayPrjName = @PayPrjName, " +
"PIID = @PIID " +
"WHERE PPID = @PPID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PPID", bG_PayProject.PPID),
new SqlParameter("@PayPrjName", bG_PayProject.PayPrjName),
new SqlParameter("@PIID", bG_PayProject.PIID)
};
int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
if (t > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayProject AddBG_PayProject(BG_PayProject bG_PayProject)
{
string sql =
"INSERT BG_PayProject (PayPrjName, PIID)" +
"VALUES (@PayPrjName, @PIID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PayPrjName", bG_PayProject.PayPrjName),
new SqlParameter("@PIID", bG_PayProject.PIID)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_PayProjectByPPID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayProject GetBG_PayProjectByPPID(int pPID)
{
string sql = "SELECT * FROM BG_PayProject WHERE PPID = @PPID";
try
{
SqlParameter para = new SqlParameter("@PPID", pPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PayProject bG_PayProject = new BG_PayProject();
bG_PayProject.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_PayProject.PayPrjName = dt.Rows[0]["PayPrjName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PayPrjName"];
bG_PayProject.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
return(bG_PayProject);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayProject AddBG_PayProject(BG_PayProject bG_PayProject)
{
string sql =
"INSERT BG_PayProject (PayPrjName, PIID)" +
"VALUES (@PayPrjName, @PIID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PayPrjName", bG_PayProject.PayPrjName),
new SqlParameter("@PIID", bG_PayProject.PIID)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_PayProjectByPPID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_PayProject(BG_PayProject bG_PayProject)
{
return(BG_PayProjectService.ModifyBG_PayProject(bG_PayProject));
}
public static bool DeleteBG_PayProject(BG_PayProject bG_PayProject)
{
return(BG_PayProjectService.DeleteBG_PayProject(bG_PayProject));
}
public static BG_PayProject AddBG_PayProject(BG_PayProject bG_PayProject)
{
return(BG_PayProjectService.AddBG_PayProject(bG_PayProject));
}
public static bool DeleteBG_PayProject(BG_PayProject bG_PayProject)
{
return(DeleteBG_PayProjectByPPID(bG_PayProject.PPID));
}
public static BG_PayProject GetBG_PayProjectByPPID(int pPID)
{
string sql = "SELECT * FROM BG_PayProject WHERE PPID = @PPID";
try
{
SqlParameter para = new SqlParameter("@PPID", pPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_PayProject bG_PayProject = new BG_PayProject();
bG_PayProject.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_PayProject.PayPrjName = dt.Rows[0]["PayPrjName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PayPrjName"];
bG_PayProject.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
return bG_PayProject;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_PayProject(BG_PayProject bG_PayProject)
{
return DeleteBG_PayProjectByPPID( bG_PayProject.PPID );
}
public static bool ModifyBG_PayProject(BG_PayProject bG_PayProject)
{
string sql =
"UPDATE BG_PayProject " +
"SET " +
"PayPrjName = @PayPrjName, " +
"PIID = @PIID " +
"WHERE PPID = @PPID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PPID", bG_PayProject.PPID),
new SqlParameter("@PayPrjName", bG_PayProject.PayPrjName),
new SqlParameter("@PIID", bG_PayProject.PIID)
};
int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
if(t>0)
{
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
