public static BG_ReimDocuments AddBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { string sql = "INSERT BG_ReimDocuments (ARID, RDType, RDCont, RDTime)" + "VALUES (@ARID, @RDType, @RDCont, @RDTime)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ARID", bG_ReimDocuments.ARID), new SqlParameter("@RDType", bG_ReimDocuments.RDType), new SqlParameter("@RDCont", bG_ReimDocuments.RDCont), new SqlParameter("@RDTime", bG_ReimDocuments.RDTime) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_ReimDocumentsByRDID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 查询一条指定报销单据 /// </summary> /// <param name="arid">报销单据ID</param> /// <returns>BGReimDocuments</returns> public static BG_ReimDocuments GetReimDocByArid(string arid) { BG_ReimDocuments rm = new BG_ReimDocuments(); try { string sqlStr = "select * from BG_ReimDocuments where ARID={0} "; sqlStr = string.Format(sqlStr, arid); DataTable dt = DBUnity.AdapterToTab(sqlStr); if (dt.Rows.Count > 0) { rm.ARID = common.IntSafeConvert(dt.Rows[0]["ARID"]); rm.RDCont = dt.Rows[0]["RdCont"].ToString(); rm.RDTime = DateTime.Parse(dt.Rows[0]["RDTime"].ToString()); rm.RDType = dt.Rows[0]["RdType"].ToString(); } } catch (Exception ex) { rm = new BG_ReimDocuments(); Log.WriteLog(ex.Message, "BudgetSys.DAL.BGReimDocumentsService.GetReimDocByArid"); } return(rm); }
public static BG_ReimDocuments GetBG_ReimDocumentsByRDID(int rDID) { string sql = "SELECT * FROM BG_ReimDocuments WHERE RDID = @RDID"; try { SqlParameter para = new SqlParameter("@RDID", rDID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_ReimDocuments bG_ReimDocuments = new BG_ReimDocuments(); bG_ReimDocuments.RDID = dt.Rows[0]["RDID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["RDID"]; bG_ReimDocuments.ARID = dt.Rows[0]["ARID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ARID"]; bG_ReimDocuments.RDType = dt.Rows[0]["RDType"] == DBNull.Value ? "" : (string)dt.Rows[0]["RDType"]; bG_ReimDocuments.RDCont = dt.Rows[0]["RDCont"] == DBNull.Value ? "" : (string)dt.Rows[0]["RDCont"]; bG_ReimDocuments.RDTime = dt.Rows[0]["RDTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["RDTime"]; return(bG_ReimDocuments); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 添加一条报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool AddARID(BG_ReimDocuments arid) { bool falg = false; try { string sqlStr = @"insert into BG_ReimDocuments(ARID,RDType,RDCont,RDTime)values(@ARID,@RDType,@RDCont,@RDTime)"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@ARID", arid.ARID), new SqlParameter("@RDType", arid.RDType), new SqlParameter("@RDCont", arid.RDCont), new SqlParameter("@RDTime", arid.RDTime) }; falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { falg = false; Log.WriteLog(ex.Message, "BudgetSys.DAL.BGReimDocumentsService.AddARID"); } return(falg); }
public static bool ModifyBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { string sql = "UPDATE BG_ReimDocuments " + "SET " + "ARID = @ARID, " + "RDType = @RDType, " + "RDCont = @RDCont, " + "RDTime = @RDTime " + "WHERE RDID = @RDID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RDID", bG_ReimDocuments.RDID), new SqlParameter("@ARID", bG_ReimDocuments.ARID), new SqlParameter("@RDType", bG_ReimDocuments.RDType), new SqlParameter("@RDCont", bG_ReimDocuments.RDCont), new SqlParameter("@RDTime", bG_ReimDocuments.RDTime) }; 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; } }
/// <summary> /// 修改指定报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool UpdReimDocuments(BG_ReimDocuments arid) { bool flag = false; try { string sqlStr = @"update BG_ReimDocuments set RDType=@RDType,RDCont=@RDCont,RDTime=@RDTime where ARID=@ARID"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@ARID", arid.ARID), new SqlParameter("@RDType", arid.RDType), new SqlParameter("@RDCont", arid.RDCont), new SqlParameter("@RDTime", arid.RDTime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BudgetSys.DAL.BGReimDocumentsService.UpdReimDocuments"); } return(flag); }
public static bool ModifyBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { return(BG_ReimDocumentsService.ModifyBG_ReimDocuments(bG_ReimDocuments)); }
public static bool DeleteBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { return(BG_ReimDocumentsService.DeleteBG_ReimDocuments(bG_ReimDocuments)); }
public static BG_ReimDocuments AddBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { return(BG_ReimDocumentsService.AddBG_ReimDocuments(bG_ReimDocuments)); }
/// <summary> /// 修改指定报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool UpdReimDocuments(BG_ReimDocuments arid) { return(BGReimDocumentsService.UpdReimDocuments(arid)); }
/// <summary> /// 添加一条报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool AddARID(BG_ReimDocuments arid) { return(BGReimDocumentsService.AddARID(arid)); }
public static bool DeleteBG_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { return(DeleteBG_ReimDocumentsByRDID(bG_ReimDocuments.RDID)); }