/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.HSPR.Tb_HSPR_CustomerLive model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@LiveID", SqlDbType.BigInt, 8), new SqlParameter("@RoomID", SqlDbType.BigInt, 8), new SqlParameter("@CustID", SqlDbType.BigInt, 8), new SqlParameter("@LiveType", SqlDbType.SmallInt, 2), new SqlParameter("@SubmitTime", SqlDbType.DateTime), new SqlParameter("@FittingTime", SqlDbType.DateTime), new SqlParameter("@StayTime", SqlDbType.DateTime), new SqlParameter("@StayType", SqlDbType.NVarChar, 20), new SqlParameter("@ChargingTime", SqlDbType.DateTime), new SqlParameter("@ChargeCause", SqlDbType.NVarChar, 50), new SqlParameter("@ChargeTime", SqlDbType.DateTime), new SqlParameter("@ContractSign", SqlDbType.NVarChar, 20), new SqlParameter("@RightsSign", SqlDbType.NVarChar, 20), new SqlParameter("@PropertyUses", SqlDbType.NVarChar, 20), new SqlParameter("@StartDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@ReletDate", SqlDbType.DateTime), new SqlParameter("@IsActive", SqlDbType.SmallInt, 2), new SqlParameter("@IsDelLive", SqlDbType.SmallInt, 2), new SqlParameter("@IsDebts", SqlDbType.SmallInt, 2), new SqlParameter("@IsSale", SqlDbType.SmallInt, 2), new SqlParameter("@PurchaseArea", SqlDbType.Decimal, 9), new SqlParameter("@PropertyArea", SqlDbType.Decimal, 9), new SqlParameter("@LiveState", SqlDbType.SmallInt, 2), new SqlParameter("@BankName", SqlDbType.NVarChar, 20), new SqlParameter("@BankIDs", SqlDbType.NVarChar, 50), new SqlParameter("@BankAccount", SqlDbType.NVarChar, 30), new SqlParameter("@BankAgreement", SqlDbType.NVarChar, 20), new SqlParameter("@BankCode", SqlDbType.NVarChar, 20), new SqlParameter("@BankNo", SqlDbType.NVarChar, 20), new SqlParameter("@OldCustID", SqlDbType.BigInt, 8), new SqlParameter("@LiveSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@SynchFlag", SqlDbType.SmallInt, 2), new SqlParameter("@BankProvince", SqlDbType.NVarChar, 50), new SqlParameter("@BankCity", SqlDbType.NVarChar, 50), new SqlParameter("@BankInfo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.LiveID; parameters[1].Value = model.RoomID; parameters[2].Value = model.CustID; parameters[3].Value = model.LiveType; parameters[4].Value = model.SubmitTime; parameters[5].Value = model.FittingTime; parameters[6].Value = model.StayTime; parameters[7].Value = model.StayType; parameters[8].Value = model.ChargingTime; parameters[9].Value = model.ChargeCause; parameters[10].Value = model.ChargeTime; parameters[11].Value = model.ContractSign; parameters[12].Value = model.RightsSign; parameters[13].Value = model.PropertyUses; parameters[14].Value = model.StartDate; parameters[15].Value = model.EndDate; parameters[16].Value = model.ReletDate; parameters[17].Value = model.IsActive; parameters[18].Value = model.IsDelLive; parameters[19].Value = model.IsDebts; parameters[20].Value = model.IsSale; parameters[21].Value = model.PurchaseArea; parameters[22].Value = model.PropertyArea; parameters[23].Value = model.LiveState; parameters[24].Value = model.BankName; parameters[25].Value = model.BankIDs; parameters[26].Value = model.BankAccount; parameters[27].Value = model.BankAgreement; parameters[28].Value = model.BankCode; parameters[29].Value = model.BankNo; parameters[30].Value = model.OldCustID; parameters[31].Value = model.LiveSynchCode; parameters[32].Value = model.SynchFlag; parameters[33].Value = model.BankProvince; parameters[34].Value = model.BankCity; parameters[35].Value = model.BankInfo; DbHelperSQL.RunProcedure("Proc_Tb_HSPR_CustomerLive_ADD", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.HSPR.Tb_HSPR_CustomerLive GetModel(long LiveID) { SqlParameter[] parameters = { new SqlParameter("@LiveID", SqlDbType.BigInt) }; parameters[0].Value = LiveID; MobileSoft.Model.HSPR.Tb_HSPR_CustomerLive model = new MobileSoft.Model.HSPR.Tb_HSPR_CustomerLive(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_HSPR_CustomerLive_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["LiveID"].ToString() != "") { model.LiveID = long.Parse(ds.Tables[0].Rows[0]["LiveID"].ToString()); } if (ds.Tables[0].Rows[0]["RoomID"].ToString() != "") { model.RoomID = long.Parse(ds.Tables[0].Rows[0]["RoomID"].ToString()); } if (ds.Tables[0].Rows[0]["CustID"].ToString() != "") { model.CustID = long.Parse(ds.Tables[0].Rows[0]["CustID"].ToString()); } if (ds.Tables[0].Rows[0]["LiveType"].ToString() != "") { model.LiveType = int.Parse(ds.Tables[0].Rows[0]["LiveType"].ToString()); } if (ds.Tables[0].Rows[0]["SubmitTime"].ToString() != "") { model.SubmitTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubmitTime"].ToString()); } if (ds.Tables[0].Rows[0]["FittingTime"].ToString() != "") { model.FittingTime = DateTime.Parse(ds.Tables[0].Rows[0]["FittingTime"].ToString()); } if (ds.Tables[0].Rows[0]["StayTime"].ToString() != "") { model.StayTime = DateTime.Parse(ds.Tables[0].Rows[0]["StayTime"].ToString()); } model.StayType = ds.Tables[0].Rows[0]["StayType"].ToString(); if (ds.Tables[0].Rows[0]["ChargingTime"].ToString() != "") { model.ChargingTime = DateTime.Parse(ds.Tables[0].Rows[0]["ChargingTime"].ToString()); } model.ChargeCause = ds.Tables[0].Rows[0]["ChargeCause"].ToString(); if (ds.Tables[0].Rows[0]["ChargeTime"].ToString() != "") { model.ChargeTime = DateTime.Parse(ds.Tables[0].Rows[0]["ChargeTime"].ToString()); } model.ContractSign = ds.Tables[0].Rows[0]["ContractSign"].ToString(); model.RightsSign = ds.Tables[0].Rows[0]["RightsSign"].ToString(); model.PropertyUses = ds.Tables[0].Rows[0]["PropertyUses"].ToString(); if (ds.Tables[0].Rows[0]["StartDate"].ToString() != "") { model.StartDate = DateTime.Parse(ds.Tables[0].Rows[0]["StartDate"].ToString()); } if (ds.Tables[0].Rows[0]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString()); } if (ds.Tables[0].Rows[0]["ReletDate"].ToString() != "") { model.ReletDate = DateTime.Parse(ds.Tables[0].Rows[0]["ReletDate"].ToString()); } if (ds.Tables[0].Rows[0]["IsActive"].ToString() != "") { model.IsActive = int.Parse(ds.Tables[0].Rows[0]["IsActive"].ToString()); } if (ds.Tables[0].Rows[0]["IsDelLive"].ToString() != "") { model.IsDelLive = int.Parse(ds.Tables[0].Rows[0]["IsDelLive"].ToString()); } if (ds.Tables[0].Rows[0]["IsDebts"].ToString() != "") { model.IsDebts = int.Parse(ds.Tables[0].Rows[0]["IsDebts"].ToString()); } if (ds.Tables[0].Rows[0]["IsSale"].ToString() != "") { model.IsSale = int.Parse(ds.Tables[0].Rows[0]["IsSale"].ToString()); } if (ds.Tables[0].Rows[0]["PurchaseArea"].ToString() != "") { model.PurchaseArea = decimal.Parse(ds.Tables[0].Rows[0]["PurchaseArea"].ToString()); } if (ds.Tables[0].Rows[0]["PropertyArea"].ToString() != "") { model.PropertyArea = decimal.Parse(ds.Tables[0].Rows[0]["PropertyArea"].ToString()); } if (ds.Tables[0].Rows[0]["LiveState"].ToString() != "") { model.LiveState = int.Parse(ds.Tables[0].Rows[0]["LiveState"].ToString()); } model.BankName = ds.Tables[0].Rows[0]["BankName"].ToString(); model.BankIDs = ds.Tables[0].Rows[0]["BankIDs"].ToString(); model.BankAccount = ds.Tables[0].Rows[0]["BankAccount"].ToString(); model.BankAgreement = ds.Tables[0].Rows[0]["BankAgreement"].ToString(); model.BankCode = ds.Tables[0].Rows[0]["BankCode"].ToString(); model.BankNo = ds.Tables[0].Rows[0]["BankNo"].ToString(); if (ds.Tables[0].Rows[0]["OldCustID"].ToString() != "") { model.OldCustID = long.Parse(ds.Tables[0].Rows[0]["OldCustID"].ToString()); } if (ds.Tables[0].Rows[0]["LiveSynchCode"].ToString() != "") { model.LiveSynchCode = new Guid(ds.Tables[0].Rows[0]["LiveSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(ds.Tables[0].Rows[0]["SynchFlag"].ToString()); } model.BankProvince = ds.Tables[0].Rows[0]["BankProvince"].ToString(); model.BankCity = ds.Tables[0].Rows[0]["BankCity"].ToString(); model.BankInfo = ds.Tables[0].Rows[0]["BankInfo"].ToString(); return(model); } else { return(null); } }