/// <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);
}
