/// <summary> /// 根据Faid查询到一条BGFixAssetPurchase记录 /// </summary> /// <param name="faid">FAID</param> /// <returns>BGFixAssetPurchase</returns> public static BG_FixAssetPurchase GetFAPByFaid(int faid) { BG_FixAssetPurchase fap = new BG_FixAssetPurchase(); string sqlStr = "select * from BG_FixAssetPurchase where FAID={0}"; sqlStr = string.Format(sqlStr, faid); try { SqlDataReader dr = DBUnity.ExecuteReader(CommandType.Text,sqlStr,null); while (dr.Read()) { fap.FAID = common.IntSafeConvert(dr["FAID"]); fap.BudID = common.IntSafeConvert(dr["BudID"]); fap.FAName = dr["FAName"].ToString(); fap.FAModel = dr["FAModel"].ToString(); fap.FABrand = dr["FABrand"].ToString(); fap.FAPrice = ParseUtil.ToDecimal(dr["FAPrice"].ToString(),0); fap.FANum =common.IntSafeConvert(dr["FANum"]); fap.FAMon = ParseUtil.ToDecimal(dr["FAMon"].ToString(), 0); fap.FAIsGovPur = dr["FAIsGovPur"].ToString(); fap.FAConfig = dr["FAConfig"].ToString(); fap.FARemark = dr["FARemark"].ToString(); fap.FATime =ParseUtil.ToDateTime(dr["FATime"].ToString(),DateTime.Now); } dr.Close(); } catch (Exception ex) { fap = null; Log.WriteLog(ex.Message, "BGFixAssetPurchaseService--GetFAPByFaid"); } return fap; }
/// <summary> /// 添加固定资产采购情况 /// </summary> /// <param name="bfp"></param> /// <returns>bool</returns> public static bool AddFix(BG_FixAssetPurchase bfp) { bool flag = false; try { string sqlStr = @"insert into BG_FixAssetPurchase(FAName,FAModel,FABrand,FAPrice,FANum,FAMon,FAIsGovPur,FAConfig,FARemark,FATime,BudID) values (@FAName,@FAModel,@FABrand,@FAPrice,@FANum,@FAMon, @FAIsGovPur,@FAConfig,@FARemark,@FATime,@BudID)"; SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@FAName",bfp.FAName), new SqlParameter("@FAModel",bfp.FAModel), new SqlParameter("@FABrand",bfp.FABrand), new SqlParameter("@FAPrice",bfp.FAPrice), new SqlParameter("@FANum",bfp.FANum), new SqlParameter("@FAMon",bfp.FAMon), new SqlParameter("@FAIsGovPur",bfp.FAIsGovPur), new SqlParameter("@FAConfig",bfp.FAConfig), new SqlParameter("@FARemark",bfp.FARemark), new SqlParameter("@BudID",bfp.BudID), new SqlParameter("@FATime",bfp.FATime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, pars) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BGFixAssetPurchaseService--AddFix"); } return flag; }
protected void btnAdd_Click(object sender, EventArgs e) { BG_FixAssetPurchase bp = new BG_FixAssetPurchase(); bp.FAName = txtSort.Text.Trim(); bp.FAModel = txtModel.Text.Trim(); bp.FABrand = txtBrand.Text.Trim(); bp.FAPrice =decimal.Parse(txtPrice.Text.Trim()); bp.FANum=int.Parse(txtNum.Text.Trim()); bp.FAMon = ParseUtil.ToDecimal(HidTotal.Value, 0); bp.FAIsGovPur = ddlIsGovper.SelectedValue; bp.FAConfig = txtConfig.Text.Trim(); bp.FARemark = txtRemark.Text.Trim(); bp.FATime = DateTime.Parse(txtTime.Text.Trim()); bp.BudID = common.IntSafeConvert(HidBudid.Value); if (BGFixAssetPurchaseManager.AddFix(bp)) { lbResult.Text = "申请添加成功"; } else { lbResult.Text = "添加失败,请重新添加"; } }
public static bool ModifyBG_FixAssetPurchase(BG_FixAssetPurchase bG_FixAssetPurchase) { return BG_FixAssetPurchaseService.ModifyBG_FixAssetPurchase(bG_FixAssetPurchase); }
public static bool DeleteBG_FixAssetPurchase(BG_FixAssetPurchase bG_FixAssetPurchase) { return BG_FixAssetPurchaseService.DeleteBG_FixAssetPurchase(bG_FixAssetPurchase); }
public static BG_FixAssetPurchase AddBG_FixAssetPurchase(BG_FixAssetPurchase bG_FixAssetPurchase) { return BG_FixAssetPurchaseService.AddBG_FixAssetPurchase(bG_FixAssetPurchase); }
/// <summary> /// 修改一条固定资产 /// </summary> /// <param name="fa"></param> /// <returns>bool</returns> public static bool UpdFix(BG_FixAssetPurchase fa) { return BGFixAssetPurchaseService.UpdFix(fa); }
/// <summary> /// 添加固定资产采购情况 /// </summary> /// <param name="bfp"></param> /// <returns>bool</returns> public static bool AddFix(BG_FixAssetPurchase bfp) { return BGFixAssetPurchaseService.AddFix(bfp); }
/// <summary> /// 修改一条固定资产 /// </summary> /// <param name="fa"></param> /// <returns>bool</returns> public static bool UpdFix(BG_FixAssetPurchase bfp) { bool falg = false; try { string sqlStr = @"update BG_FixAssetPurchase set FAMon=@FAMon,FAName=@FAName,FAModel=@FAModel, FABrand=@FABrand,FAPrice=@FAPrice,FAIsGovPur=@FAIsGovPur,FARemark=@FARemark,FAConfig=@FAConfig,FANum=@FANum where FAID=@FAID"; SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@FAName",bfp.FAName), new SqlParameter("@FAModel",bfp.FAModel), new SqlParameter("@FABrand",bfp.FABrand), new SqlParameter("@FAPrice",bfp.FAPrice), new SqlParameter("@FANum",bfp.FANum), new SqlParameter("@FAMon",bfp.FAMon), new SqlParameter("@FAIsGovPur",bfp.FAIsGovPur), new SqlParameter("@FAConfig",bfp.FAConfig), new SqlParameter("@FARemark",bfp.FARemark), //new SqlParameter("@BudID",bfp.BudID), //new SqlParameter("@FATime",bfp.FATime), new SqlParameter("@FAID",bfp.FAID) }; falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, pars) > 0; } catch (Exception ex) { falg = false; Log.WriteLog(ex.Message, "BGFixAssetPurchaseService--UpdFix"); } return falg; }