public static BG_PreviewData AddBG_PreviewData(BG_PreviewData bG_PreviewData)
{
string sql =
"INSERT BG_PreviewData (PSType1, PSType2, PSName, PDBaseData, PDBaseLYData, PDProjectData, PDProjectLYData)" +
"VALUES (@PSType1, @PSType2, @PSName, @PDBaseData, @PDBaseLYData, @PDProjectData, @PDProjectLYData)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PSType1", bG_PreviewData.PSType1),
new SqlParameter("@PSType2", bG_PreviewData.PSType2),
new SqlParameter("@PSName", bG_PreviewData.PSName),
new SqlParameter("@PDBaseData", bG_PreviewData.PDBaseData),
new SqlParameter("@PDBaseLYData", bG_PreviewData.PDBaseLYData),
new SqlParameter("@PDProjectData", bG_PreviewData.PDProjectData),
new SqlParameter("@PDProjectLYData", bG_PreviewData.PDProjectLYData)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_PreviewDataByPSID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PreviewData AddBG_PreviewData(BG_PreviewData bG_PreviewData)
{
string sql =
"INSERT BG_PreviewData (PSType1, PSType2, PSName, PDBaseData, PDBaseLYData, PDProjectData, PDProjectLYData)" +
"VALUES (@PSType1, @PSType2, @PSName, @PDBaseData, @PDBaseLYData, @PDProjectData, @PDProjectLYData)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PSType1", bG_PreviewData.PSType1),
new SqlParameter("@PSType2", bG_PreviewData.PSType2),
new SqlParameter("@PSName", bG_PreviewData.PSName),
new SqlParameter("@PDBaseData", bG_PreviewData.PDBaseData),
new SqlParameter("@PDBaseLYData", bG_PreviewData.PDBaseLYData),
new SqlParameter("@PDProjectData", bG_PreviewData.PDProjectData),
new SqlParameter("@PDProjectLYData", bG_PreviewData.PDProjectLYData)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_PreviewDataByPSID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PreviewData GetBG_PreviewDataByPSID(int pSID)
{
string sql = "SELECT * FROM BG_PreviewData WHERE PSID = @PSID";
try
{
SqlParameter para = new SqlParameter("@PSID", pSID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PreviewData bG_PreviewData = new BG_PreviewData();
bG_PreviewData.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PreviewData.PSType1 = dt.Rows[0]["PSType1"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType1"];
bG_PreviewData.PSType2 = dt.Rows[0]["PSType2"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType2"];
bG_PreviewData.PSName = dt.Rows[0]["PSName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSName"];
bG_PreviewData.PDBaseData = dt.Rows[0]["PDBaseData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseData"];
bG_PreviewData.PDBaseLYData = dt.Rows[0]["PDBaseLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseLYData"];
bG_PreviewData.PDProjectData = dt.Rows[0]["PDProjectData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectData"];
bG_PreviewData.PDProjectLYData = dt.Rows[0]["PDProjectLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectLYData"];
return(bG_PreviewData);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_PreviewData(BG_PreviewData bG_PreviewData)
{
string sql =
"UPDATE BG_PreviewData " +
"SET " +
"PSType1 = @PSType1, " +
"PSType2 = @PSType2, " +
"PSName = @PSName, " +
"PDBaseData = @PDBaseData, " +
"PDBaseLYData = @PDBaseLYData, " +
"PDProjectData = @PDProjectData, " +
"PDProjectLYData = @PDProjectLYData " +
"WHERE PSID = @PSID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PSID", bG_PreviewData.PSID),
new SqlParameter("@PSType1", bG_PreviewData.PSType1),
new SqlParameter("@PSType2", bG_PreviewData.PSType2),
new SqlParameter("@PSName", bG_PreviewData.PSName),
new SqlParameter("@PDBaseData", bG_PreviewData.PDBaseData),
new SqlParameter("@PDBaseLYData", bG_PreviewData.PDBaseLYData),
new SqlParameter("@PDProjectData", bG_PreviewData.PDProjectData),
new SqlParameter("@PDProjectLYData", bG_PreviewData.PDProjectLYData)
};
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 void Edit(int id, string field, string oldValue, string newValue, object customer)
{
string message = "<b>编号:</b> {0}<br /><b>科目:</b> {1}<br /><b>原经费:</b> {2}<br /><b>更改经费:</b> {3}";
// Send Message...
X.Msg.Notify(new NotificationConfig()
{
Title = "Edit Record #" + id.ToString(),
Html = string.Format(message, id, field, oldValue, newValue),
Width = 250
}).Show();
BG_PreviewData pd = BG_PreviewDataManager.GetBG_PreviewDataByPSID(id);
pd.PDProjectData = Convert.ToDecimal(newValue);
BG_PreviewDataManager.ModifyBG_PreviewData(pd);
PreviewDataBind();
}
public static BG_PreviewData GetBG_PreviewDataByPSID(int pSID)
{
string sql = "SELECT * FROM BG_PreviewData WHERE PSID = @PSID";
try
{
SqlParameter para = new SqlParameter("@PSID", pSID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_PreviewData bG_PreviewData = new BG_PreviewData();
bG_PreviewData.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PreviewData.PSType1 = dt.Rows[0]["PSType1"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType1"];
bG_PreviewData.PSType2 = dt.Rows[0]["PSType2"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType2"];
bG_PreviewData.PSName = dt.Rows[0]["PSName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSName"];
bG_PreviewData.PDBaseData = dt.Rows[0]["PDBaseData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseData"];
bG_PreviewData.PDBaseLYData = dt.Rows[0]["PDBaseLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseLYData"];
bG_PreviewData.PDProjectData = dt.Rows[0]["PDProjectData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectData"];
bG_PreviewData.PDProjectLYData = dt.Rows[0]["PDProjectLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectLYData"];
return bG_PreviewData;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return DeleteBG_PreviewDataByPSID( bG_PreviewData.PSID );
}
public static bool ModifyBG_PreviewData(BG_PreviewData bG_PreviewData)
{
string sql =
"UPDATE BG_PreviewData " +
"SET " +
"PSType1 = @PSType1, " +
"PSType2 = @PSType2, " +
"PSName = @PSName, " +
"PDBaseData = @PDBaseData, " +
"PDBaseLYData = @PDBaseLYData, " +
"PDProjectData = @PDProjectData, " +
"PDProjectLYData = @PDProjectLYData " +
"WHERE PSID = @PSID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PSID", bG_PreviewData.PSID),
new SqlParameter("@PSType1", bG_PreviewData.PSType1),
new SqlParameter("@PSType2", bG_PreviewData.PSType2),
new SqlParameter("@PSName", bG_PreviewData.PSName),
new SqlParameter("@PDBaseData", bG_PreviewData.PDBaseData),
new SqlParameter("@PDBaseLYData", bG_PreviewData.PDBaseLYData),
new SqlParameter("@PDProjectData", bG_PreviewData.PDProjectData),
new SqlParameter("@PDProjectLYData", bG_PreviewData.PDProjectLYData)
};
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_PreviewData(BG_PreviewData bG_PreviewData)
{
return BG_PreviewDataService.ModifyBG_PreviewData(bG_PreviewData);
}
public static bool DeleteBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return BG_PreviewDataService.DeleteBG_PreviewData(bG_PreviewData);
}
public static BG_PreviewData AddBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return BG_PreviewDataService.AddBG_PreviewData(bG_PreviewData);
}
public static bool DeleteBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return(DeleteBG_PreviewDataByPSID(bG_PreviewData.PSID));
}
public static bool ModifyBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return(BG_PreviewDataService.ModifyBG_PreviewData(bG_PreviewData));
}
public static bool DeleteBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return(BG_PreviewDataService.DeleteBG_PreviewData(bG_PreviewData));
}
public static BG_PreviewData AddBG_PreviewData(BG_PreviewData bG_PreviewData)
{
return(BG_PreviewDataService.AddBG_PreviewData(bG_PreviewData));
}
