/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.Unify.Tb_Unify_CustomerLive model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@LiveSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CommSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CustSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@RoomSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UnLiveID", SqlDbType.BigInt, 8), new SqlParameter("@LiveType", SqlDbType.SmallInt, 2), new SqlParameter("@L_BroadbandNum", SqlDbType.NVarChar, 30), new SqlParameter("@L_FixedTel", SqlDbType.NVarChar, 50), new SqlParameter("@L_MobilePhone", SqlDbType.NVarChar, 50), new SqlParameter("@L_IPTVAccount", SqlDbType.NVarChar, 50), 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("@SynchFlag", SqlDbType.SmallInt, 2), new SqlParameter("@OrdSNum", SqlDbType.BigInt, 8) }; parameters[0].Value = model.LiveSynchCode; parameters[1].Value = model.CommSynchCode; parameters[2].Value = model.CustSynchCode; parameters[3].Value = model.RoomSynchCode; parameters[4].Value = model.UnLiveID; parameters[5].Value = model.LiveType; parameters[6].Value = model.L_BroadbandNum; parameters[7].Value = model.L_FixedTel; parameters[8].Value = model.L_MobilePhone; parameters[9].Value = model.L_IPTVAccount; parameters[10].Value = model.SubmitTime; parameters[11].Value = model.FittingTime; parameters[12].Value = model.StayTime; parameters[13].Value = model.StayType; parameters[14].Value = model.ChargingTime; parameters[15].Value = model.ChargeCause; parameters[16].Value = model.ChargeTime; parameters[17].Value = model.ContractSign; parameters[18].Value = model.RightsSign; parameters[19].Value = model.PropertyUses; parameters[20].Value = model.StartDate; parameters[21].Value = model.EndDate; parameters[22].Value = model.ReletDate; parameters[23].Value = model.IsActive; parameters[24].Value = model.IsDelLive; parameters[25].Value = model.IsDebts; parameters[26].Value = model.IsSale; parameters[27].Value = model.PurchaseArea; parameters[28].Value = model.PropertyArea; parameters[29].Value = model.LiveState; parameters[30].Value = model.BankName; parameters[31].Value = model.BankIDs; parameters[32].Value = model.BankAccount; parameters[33].Value = model.BankAgreement; parameters[34].Value = model.BankCode; parameters[35].Value = model.BankNo; parameters[36].Value = model.OldCustID; parameters[37].Value = model.SynchFlag; parameters[38].Value = model.OrdSNum; DbHelperSQL.RunProcedure("Proc_Tb_Unify_CustomerLive_ADD", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.Unify.Tb_Unify_CustomerLive GetModel(Guid LiveSynchCode) { SqlParameter[] parameters = { new SqlParameter("@LiveSynchCode", SqlDbType.UniqueIdentifier) }; parameters[0].Value = LiveSynchCode; MobileSoft.Model.Unify.Tb_Unify_CustomerLive model = new MobileSoft.Model.Unify.Tb_Unify_CustomerLive(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Unify_CustomerLive_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { 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]["CommSynchCode"].ToString() != "") { model.CommSynchCode = new Guid(ds.Tables[0].Rows[0]["CommSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["CustSynchCode"].ToString() != "") { model.CustSynchCode = new Guid(ds.Tables[0].Rows[0]["CustSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["RoomSynchCode"].ToString() != "") { model.RoomSynchCode = new Guid(ds.Tables[0].Rows[0]["RoomSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["UnLiveID"].ToString() != "") { model.UnLiveID = long.Parse(ds.Tables[0].Rows[0]["UnLiveID"].ToString()); } if (ds.Tables[0].Rows[0]["LiveType"].ToString() != "") { model.LiveType = int.Parse(ds.Tables[0].Rows[0]["LiveType"].ToString()); } model.L_BroadbandNum = ds.Tables[0].Rows[0]["L_BroadbandNum"].ToString(); model.L_FixedTel = ds.Tables[0].Rows[0]["L_FixedTel"].ToString(); model.L_MobilePhone = ds.Tables[0].Rows[0]["L_MobilePhone"].ToString(); model.L_IPTVAccount = ds.Tables[0].Rows[0]["L_IPTVAccount"].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]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(ds.Tables[0].Rows[0]["SynchFlag"].ToString()); } if (ds.Tables[0].Rows[0]["OrdSNum"].ToString() != "") { model.OrdSNum = long.Parse(ds.Tables[0].Rows[0]["OrdSNum"].ToString()); } return(model); } else { return(null); } }