/// <summary> /// 增加一条数据 /// </summary> public void Add(ehome.Model.Unify.Tb_Unify_Community model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@CommSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CorpSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UnCommID", SqlDbType.BigInt, 8), new SqlParameter("@CommID", SqlDbType.Int, 4), new SqlParameter("@CommName", SqlDbType.NVarChar, 50), new SqlParameter("@CommKind", SqlDbType.NVarChar, 20), new SqlParameter("@ManageTime", SqlDbType.DateTime), new SqlParameter("@ManageKind", SqlDbType.NVarChar, 20), new SqlParameter("@ProvinceID", SqlDbType.Int, 4), new SqlParameter("@CityID", SqlDbType.Int, 4), new SqlParameter("@BoroughID", SqlDbType.Int, 4), new SqlParameter("@Street", SqlDbType.NVarChar, 50), new SqlParameter("@GateSign", SqlDbType.NVarChar, 20), new SqlParameter("@CommAddress", SqlDbType.NVarChar, 50), new SqlParameter("@CommPost", SqlDbType.NVarChar, 10), new SqlParameter("@RegDate", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2), new SqlParameter("@SynchFlag", SqlDbType.SmallInt, 2), new SqlParameter("@CommSNum", SqlDbType.Int, 4), new SqlParameter("@CommunityName", SqlDbType.NVarChar, 50), new SqlParameter("@CommunityCode", SqlDbType.NVarChar, 40) }; parameters[0].Value = model.CommSynchCode; parameters[1].Value = model.CorpSynchCode; parameters[2].Value = model.UnCommID; parameters[3].Value = model.CommID; parameters[4].Value = model.CommName; parameters[5].Value = model.CommKind; parameters[6].Value = model.ManageTime; parameters[7].Value = model.ManageKind; parameters[8].Value = model.ProvinceID; parameters[9].Value = model.CityID; parameters[10].Value = model.BoroughID; parameters[11].Value = model.Street; parameters[12].Value = model.GateSign; parameters[13].Value = model.CommAddress; parameters[14].Value = model.CommPost; parameters[15].Value = model.RegDate; parameters[16].Value = model.IsDelete; parameters[17].Value = model.SynchFlag; parameters[18].Value = model.CommSNum; parameters[19].Value = model.CommunityName; parameters[20].Value = model.CommunityCode; DbHelperSQL.RunProcedure("Proc_Tb_Unify_Community_ADD", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public ehome.Model.Unify.Tb_Unify_Community GetModel(Guid CommSynchCode) { SqlParameter[] parameters = { new SqlParameter("@CommSynchCode", SqlDbType.UniqueIdentifier) }; parameters[0].Value = CommSynchCode; ehome.Model.Unify.Tb_Unify_Community model = new ehome.Model.Unify.Tb_Unify_Community(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Unify_Community_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { 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]["CorpSynchCode"].ToString() != "") { model.CorpSynchCode = new Guid(ds.Tables[0].Rows[0]["CorpSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["UnCommID"].ToString() != "") { model.UnCommID = long.Parse(ds.Tables[0].Rows[0]["UnCommID"].ToString()); } if (ds.Tables[0].Rows[0]["CommID"].ToString() != "") { model.CommID = int.Parse(ds.Tables[0].Rows[0]["CommID"].ToString()); } model.CommName = ds.Tables[0].Rows[0]["CommName"].ToString(); model.CommKind = ds.Tables[0].Rows[0]["CommKind"].ToString(); if (ds.Tables[0].Rows[0]["ManageTime"].ToString() != "") { model.ManageTime = DateTime.Parse(ds.Tables[0].Rows[0]["ManageTime"].ToString()); } model.ManageKind = ds.Tables[0].Rows[0]["ManageKind"].ToString(); if (ds.Tables[0].Rows[0]["ProvinceID"].ToString() != "") { model.ProvinceID = int.Parse(ds.Tables[0].Rows[0]["ProvinceID"].ToString()); } if (ds.Tables[0].Rows[0]["CityID"].ToString() != "") { model.CityID = int.Parse(ds.Tables[0].Rows[0]["CityID"].ToString()); } if (ds.Tables[0].Rows[0]["BoroughID"].ToString() != "") { model.BoroughID = int.Parse(ds.Tables[0].Rows[0]["BoroughID"].ToString()); } model.Street = ds.Tables[0].Rows[0]["Street"].ToString(); model.GateSign = ds.Tables[0].Rows[0]["GateSign"].ToString(); model.CommAddress = ds.Tables[0].Rows[0]["CommAddress"].ToString(); model.CommPost = ds.Tables[0].Rows[0]["CommPost"].ToString(); if (ds.Tables[0].Rows[0]["RegDate"].ToString() != "") { model.RegDate = DateTime.Parse(ds.Tables[0].Rows[0]["RegDate"].ToString()); } if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].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]["CommSNum"].ToString() != "") { model.CommSNum = int.Parse(ds.Tables[0].Rows[0]["CommSNum"].ToString()); } model.CommunityName = ds.Tables[0].Rows[0]["CommunityName"].ToString(); model.CommunityCode = ds.Tables[0].Rows[0]["CommunityCode"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ehome.Model.Unify.Tb_Unify_Community model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ehome.Model.Unify.Tb_Unify_Community model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <ehome.Model.Unify.Tb_Unify_Community> DataTableToList(DataTable dt) { List <ehome.Model.Unify.Tb_Unify_Community> modelList = new List <ehome.Model.Unify.Tb_Unify_Community>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ehome.Model.Unify.Tb_Unify_Community model; for (int n = 0; n < rowsCount; n++) { model = new ehome.Model.Unify.Tb_Unify_Community(); if (dt.Rows[n]["CommSynchCode"].ToString() != "") { model.CommSynchCode = new Guid(dt.Rows[n]["CommSynchCode"].ToString()); } if (dt.Rows[n]["CorpSynchCode"].ToString() != "") { model.CorpSynchCode = new Guid(dt.Rows[n]["CorpSynchCode"].ToString()); } //model.UnCommID=dt.Rows[n]["UnCommID"].ToString(); if (dt.Rows[n]["CommID"].ToString() != "") { model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString()); } model.CommName = dt.Rows[n]["CommName"].ToString(); model.CommKind = dt.Rows[n]["CommKind"].ToString(); if (dt.Rows[n]["ManageTime"].ToString() != "") { model.ManageTime = DateTime.Parse(dt.Rows[n]["ManageTime"].ToString()); } model.ManageKind = dt.Rows[n]["ManageKind"].ToString(); if (dt.Rows[n]["ProvinceID"].ToString() != "") { model.ProvinceID = int.Parse(dt.Rows[n]["ProvinceID"].ToString()); } if (dt.Rows[n]["CityID"].ToString() != "") { model.CityID = int.Parse(dt.Rows[n]["CityID"].ToString()); } if (dt.Rows[n]["BoroughID"].ToString() != "") { model.BoroughID = int.Parse(dt.Rows[n]["BoroughID"].ToString()); } model.Street = dt.Rows[n]["Street"].ToString(); model.GateSign = dt.Rows[n]["GateSign"].ToString(); model.CommAddress = dt.Rows[n]["CommAddress"].ToString(); model.CommPost = dt.Rows[n]["CommPost"].ToString(); if (dt.Rows[n]["RegDate"].ToString() != "") { model.RegDate = DateTime.Parse(dt.Rows[n]["RegDate"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } if (dt.Rows[n]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString()); } if (dt.Rows[n]["CommSNum"].ToString() != "") { model.CommSNum = int.Parse(dt.Rows[n]["CommSNum"].ToString()); } model.CommunityName = dt.Rows[n]["CommunityName"].ToString(); model.CommunityCode = dt.Rows[n]["CommunityCode"].ToString(); modelList.Add(model); } } return(modelList); }