public static BG_MonPayPlan_Attach AddBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
string sql =
"INSERT BG_MonPayPlan_Attach (PIID, MPFunding, DeptID, MPTime, MPRemark, MPFundingAdd, CPATimes, CPID)" +
"VALUES (@PIID, @MPFunding, @DeptID, @MPTime, @MPRemark, @MPFundingAdd, @CPATimes, @CPID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_MonPayPlan_Attach.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_Attach.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_Attach.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_Attach.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_Attach.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_Attach.MPFundingAdd),
new SqlParameter("@CPATimes", bG_MonPayPlan_Attach.CPATimes),
new SqlParameter("@CPID", bG_MonPayPlan_Attach.CPID)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_MonPayPlan_AttachByCPAID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlan_Attach AddBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
string sql =
"INSERT BG_MonPayPlan_Attach (PIID, MPFunding, DeptID, MPTime, MPRemark, MPFundingAdd, CPATimes, CPID)" +
"VALUES (@PIID, @MPFunding, @DeptID, @MPTime, @MPRemark, @MPFundingAdd, @CPATimes, @CPID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_MonPayPlan_Attach.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_Attach.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_Attach.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_Attach.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_Attach.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_Attach.MPFundingAdd),
new SqlParameter("@CPATimes", bG_MonPayPlan_Attach.CPATimes),
new SqlParameter("@CPID", bG_MonPayPlan_Attach.CPID)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_MonPayPlan_AttachByCPAID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
string sql =
"UPDATE BG_MonPayPlan_Attach " +
"SET " +
"PIID = @PIID, " +
"MPFunding = @MPFunding, " +
"DeptID = @DeptID, " +
"MPTime = @MPTime, " +
"MPRemark = @MPRemark, " +
"MPFundingAdd = @MPFundingAdd, " +
"CPATimes = @CPATimes, " +
"CPID = @CPID " +
"WHERE CPAID = @CPAID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CPAID", bG_MonPayPlan_Attach.CPAID),
new SqlParameter("@PIID", bG_MonPayPlan_Attach.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_Attach.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_Attach.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_Attach.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_Attach.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_Attach.MPFundingAdd),
new SqlParameter("@CPATimes", bG_MonPayPlan_Attach.CPATimes),
new SqlParameter("@CPID", bG_MonPayPlan_Attach.CPID)
};
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_MonPayPlan_Attach GetBG_MonPayPlan_AttachByCPAID(int cPAID)
{
string sql = "SELECT * FROM BG_MonPayPlan_Attach WHERE CPAID = @CPAID";
try
{
SqlParameter para = new SqlParameter("@CPAID", cPAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_MonPayPlan_Attach bG_MonPayPlan_Attach = new BG_MonPayPlan_Attach();
bG_MonPayPlan_Attach.CPAID = dt.Rows[0]["CPAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPAID"];
bG_MonPayPlan_Attach.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_MonPayPlan_Attach.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"];
bG_MonPayPlan_Attach.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlan_Attach.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"];
bG_MonPayPlan_Attach.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"];
bG_MonPayPlan_Attach.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"];
bG_MonPayPlan_Attach.CPATimes = dt.Rows[0]["CPATimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPATimes"];
bG_MonPayPlan_Attach.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
return(bG_MonPayPlan_Attach);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return(DeleteBG_MonPayPlan_AttachByCPAID(bG_MonPayPlan_Attach.CPAID));
}
public static bool ModifyBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return(BG_MonPayPlan_AttachService.ModifyBG_MonPayPlan_Attach(bG_MonPayPlan_Attach));
}
public static bool DeleteBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return(BG_MonPayPlan_AttachService.DeleteBG_MonPayPlan_Attach(bG_MonPayPlan_Attach));
}
public static BG_MonPayPlan_Attach AddBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return(BG_MonPayPlan_AttachService.AddBG_MonPayPlan_Attach(bG_MonPayPlan_Attach));
}
public static BG_MonPayPlan_Attach GetBG_MonPayPlan_AttachByCPAID(int cPAID)
{
string sql = "SELECT * FROM BG_MonPayPlan_Attach WHERE CPAID = @CPAID";
try
{
SqlParameter para = new SqlParameter("@CPAID", cPAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_MonPayPlan_Attach bG_MonPayPlan_Attach = new BG_MonPayPlan_Attach();
bG_MonPayPlan_Attach.CPAID = dt.Rows[0]["CPAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPAID"];
bG_MonPayPlan_Attach.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_MonPayPlan_Attach.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"];
bG_MonPayPlan_Attach.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlan_Attach.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"];
bG_MonPayPlan_Attach.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"];
bG_MonPayPlan_Attach.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"];
bG_MonPayPlan_Attach.CPATimes = dt.Rows[0]["CPATimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPATimes"];
bG_MonPayPlan_Attach.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
return bG_MonPayPlan_Attach;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return DeleteBG_MonPayPlan_AttachByCPAID( bG_MonPayPlan_Attach.CPAID );
}
public static bool ModifyBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
string sql =
"UPDATE BG_MonPayPlan_Attach " +
"SET " +
"PIID = @PIID, " +
"MPFunding = @MPFunding, " +
"DeptID = @DeptID, " +
"MPTime = @MPTime, " +
"MPRemark = @MPRemark, " +
"MPFundingAdd = @MPFundingAdd, " +
"CPATimes = @CPATimes, " +
"CPID = @CPID " +
"WHERE CPAID = @CPAID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CPAID", bG_MonPayPlan_Attach.CPAID),
new SqlParameter("@PIID", bG_MonPayPlan_Attach.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_Attach.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_Attach.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_Attach.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_Attach.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_Attach.MPFundingAdd),
new SqlParameter("@CPATimes", bG_MonPayPlan_Attach.CPATimes),
new SqlParameter("@CPID", bG_MonPayPlan_Attach.CPID)
};
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 bool ModifyBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return BG_MonPayPlan_AttachService.ModifyBG_MonPayPlan_Attach(bG_MonPayPlan_Attach);
}
public static bool DeleteBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return BG_MonPayPlan_AttachService.DeleteBG_MonPayPlan_Attach(bG_MonPayPlan_Attach);
}
public static BG_MonPayPlan_Attach AddBG_MonPayPlan_Attach(BG_MonPayPlan_Attach bG_MonPayPlan_Attach)
{
return BG_MonPayPlan_AttachService.AddBG_MonPayPlan_Attach(bG_MonPayPlan_Attach);
}
