public static BG_PreviewStruct AddBG_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { string sql = "INSERT BG_PreviewStruct (PSType, PSType2, PSName, PDData, PDLYData)" + "VALUES (@PSType, @PSType2, @PSName, @PDData, @PDLYData)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PSType", bG_PreviewStruct.PSType), new SqlParameter("@PSType2", bG_PreviewStruct.PSType2), new SqlParameter("@PSName", bG_PreviewStruct.PSName), new SqlParameter("@PDData", bG_PreviewStruct.PDData), new SqlParameter("@PDLYData", bG_PreviewStruct.PDLYData) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_PreviewStructByPSID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_PreviewStruct GetBG_PreviewStructByPSID(int pSID) { string sql = "SELECT * FROM BG_PreviewStruct WHERE PSID = @PSID"; try { SqlParameter para = new SqlParameter("@PSID", pSID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_PreviewStruct bG_PreviewStruct = new BG_PreviewStruct(); bG_PreviewStruct.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"]; bG_PreviewStruct.PSType = dt.Rows[0]["PSType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType"]; bG_PreviewStruct.PSType2 = dt.Rows[0]["PSType2"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType2"]; bG_PreviewStruct.PSName = dt.Rows[0]["PSName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSName"]; bG_PreviewStruct.PDData = dt.Rows[0]["PDData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDData"]; bG_PreviewStruct.PDLYData = dt.Rows[0]["PDLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDLYData"]; return(bG_PreviewStruct); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { string sql = "UPDATE BG_PreviewStruct " + "SET " + "PSType = @PSType, " + "PSType2 = @PSType2, " + "PSName = @PSName, " + "PDData = @PDData, " + "PDLYData = @PDLYData " + "WHERE PSID = @PSID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PSID", bG_PreviewStruct.PSID), new SqlParameter("@PSType", bG_PreviewStruct.PSType), new SqlParameter("@PSType2", bG_PreviewStruct.PSType2), new SqlParameter("@PSName", bG_PreviewStruct.PSName), new SqlParameter("@PDData", bG_PreviewStruct.PDData), new SqlParameter("@PDLYData", bG_PreviewStruct.PDLYData) }; 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_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { return(BG_PreviewStructService.ModifyBG_PreviewStruct(bG_PreviewStruct)); }
public static bool DeleteBG_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { return(BG_PreviewStructService.DeleteBG_PreviewStruct(bG_PreviewStruct)); }
public static BG_PreviewStruct AddBG_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { return(BG_PreviewStructService.AddBG_PreviewStruct(bG_PreviewStruct)); }
public static bool DeleteBG_PreviewStruct(BG_PreviewStruct bG_PreviewStruct) { return(DeleteBG_PreviewStructByPSID(bG_PreviewStruct.PSID)); }