/// <summary>
/// 增加一条数据
/// </summary>
public void Add(MobileSoft.Model.System.Tb_System_BusinessCorp model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@BussId", SqlDbType.BigInt, 8),
new SqlParameter("@RegBigType", SqlDbType.NVarChar, 20),
new SqlParameter("@RegSmallType", SqlDbType.NVarChar, 20),
new SqlParameter("@BussName", SqlDbType.NVarChar, 100),
new SqlParameter("@BussShortName", SqlDbType.NVarChar, 20),
new SqlParameter("@Province", SqlDbType.NVarChar, 20),
new SqlParameter("@City", SqlDbType.NVarChar, 20),
new SqlParameter("@Borough", SqlDbType.NVarChar, 20),
new SqlParameter("@LoginCode", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginPassWD", SqlDbType.NVarChar, 30),
new SqlParameter("@BussAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@BussZipCode", SqlDbType.NVarChar, 10),
new SqlParameter("@BussLinkMan", SqlDbType.NVarChar, 20),
new SqlParameter("@BussMobileTel", SqlDbType.NVarChar, 50),
new SqlParameter("@BussWorkedTel", SqlDbType.NVarChar, 50),
new SqlParameter("@BussEmail", SqlDbType.NVarChar, 50),
new SqlParameter("@BussWebName", SqlDbType.NVarChar, 100),
new SqlParameter("@BussQQ", SqlDbType.NVarChar, 20),
new SqlParameter("@BussWeiXin", SqlDbType.NVarChar, 50),
new SqlParameter("@LogoImgUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@MapImgUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@SysDir", SqlDbType.NVarChar, 10),
new SqlParameter("@SysVersion", SqlDbType.NVarChar, 20),
new SqlParameter("@RegDate", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2),
new SqlParameter("@BussSNum", SqlDbType.Int, 4),
new SqlParameter("@BussSynchCode", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@SynchFlag", SqlDbType.SmallInt, 2),
new SqlParameter("@IsRecommend", SqlDbType.SmallInt, 2),
new SqlParameter("@RecommendIndex", SqlDbType.NVarChar, 10),
new SqlParameter("@RecommendTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@RecommendContent", SqlDbType.NVarChar, 500),
new SqlParameter("@ImgLogo1", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo2", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo3", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo4", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo5", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo6", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo7", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo8", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo9", SqlDbType.NVarChar, 200),
new SqlParameter("@ImgLogo10", SqlDbType.NVarChar, 200),
new SqlParameter("@VisitCount", SqlDbType.Int, 4)
};
parameters[0].Value = model.BussId;
parameters[1].Value = model.RegBigType;
parameters[2].Value = model.RegSmallType;
parameters[3].Value = model.BussName;
parameters[4].Value = model.BussShortName;
parameters[5].Value = model.Province;
parameters[6].Value = model.City;
parameters[7].Value = model.Borough;
parameters[8].Value = model.LoginCode;
parameters[9].Value = model.LoginPassWD;
parameters[10].Value = model.BussAddress;
parameters[11].Value = model.BussZipCode;
parameters[12].Value = model.BussLinkMan;
parameters[13].Value = model.BussMobileTel;
parameters[14].Value = model.BussWorkedTel;
parameters[15].Value = model.BussEmail;
parameters[16].Value = model.BussWebName;
parameters[17].Value = model.BussQQ;
parameters[18].Value = model.BussWeiXin;
parameters[19].Value = model.LogoImgUrl;
parameters[20].Value = model.MapImgUrl;
parameters[21].Value = model.SysDir;
parameters[22].Value = model.SysVersion;
parameters[23].Value = model.RegDate;
parameters[24].Value = model.IsDelete;
parameters[25].Value = model.BussSNum;
parameters[26].Value = model.BussSynchCode;
parameters[27].Value = model.SynchFlag;
parameters[28].Value = model.IsRecommend;
parameters[29].Value = model.RecommendIndex;
parameters[30].Value = model.RecommendTitle;
parameters[31].Value = model.RecommendContent;
parameters[32].Value = model.ImgLogo1;
parameters[33].Value = model.ImgLogo2;
parameters[34].Value = model.ImgLogo3;
parameters[35].Value = model.ImgLogo4;
parameters[36].Value = model.ImgLogo5;
parameters[37].Value = model.ImgLogo6;
parameters[38].Value = model.ImgLogo7;
parameters[39].Value = model.ImgLogo8;
parameters[40].Value = model.ImgLogo9;
parameters[41].Value = model.ImgLogo10;
parameters[42].Value = model.VisitCount;
DbHelperSQL.RunProcedure("Proc_Tb_System_BusinessCorp_ADD", parameters, out rowsAffected);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MobileSoft.Model.System.Tb_System_BusinessCorp GetModel(long BussId)
{
SqlParameter[] parameters =
{
new SqlParameter("@BussId", SqlDbType.BigInt)
};
parameters[0].Value = BussId;
MobileSoft.Model.System.Tb_System_BusinessCorp model = new MobileSoft.Model.System.Tb_System_BusinessCorp();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_System_BusinessCorp_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["BussId"].ToString() != "")
{
model.BussId = long.Parse(ds.Tables[0].Rows[0]["BussId"].ToString());
}
model.RegBigType = ds.Tables[0].Rows[0]["RegBigType"].ToString();
model.RegSmallType = ds.Tables[0].Rows[0]["RegSmallType"].ToString();
model.BussName = ds.Tables[0].Rows[0]["BussName"].ToString();
model.BussShortName = ds.Tables[0].Rows[0]["BussShortName"].ToString();
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
model.City = ds.Tables[0].Rows[0]["City"].ToString();
model.Borough = ds.Tables[0].Rows[0]["Borough"].ToString();
model.LoginCode = ds.Tables[0].Rows[0]["LoginCode"].ToString();
model.LoginPassWD = ds.Tables[0].Rows[0]["LoginPassWD"].ToString();
model.BussAddress = ds.Tables[0].Rows[0]["BussAddress"].ToString();
model.BussZipCode = ds.Tables[0].Rows[0]["BussZipCode"].ToString();
model.BussLinkMan = ds.Tables[0].Rows[0]["BussLinkMan"].ToString();
model.BussMobileTel = ds.Tables[0].Rows[0]["BussMobileTel"].ToString();
model.BussWorkedTel = ds.Tables[0].Rows[0]["BussWorkedTel"].ToString();
model.BussEmail = ds.Tables[0].Rows[0]["BussEmail"].ToString();
model.BussWebName = ds.Tables[0].Rows[0]["BussWebName"].ToString();
model.BussQQ = ds.Tables[0].Rows[0]["BussQQ"].ToString();
model.BussWeiXin = ds.Tables[0].Rows[0]["BussWeiXin"].ToString();
model.LogoImgUrl = ds.Tables[0].Rows[0]["LogoImgUrl"].ToString();
model.MapImgUrl = ds.Tables[0].Rows[0]["MapImgUrl"].ToString();
model.SysDir = ds.Tables[0].Rows[0]["SysDir"].ToString();
model.SysVersion = ds.Tables[0].Rows[0]["SysVersion"].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]["BussSNum"].ToString() != "")
{
model.BussSNum = int.Parse(ds.Tables[0].Rows[0]["BussSNum"].ToString());
}
if (ds.Tables[0].Rows[0]["BussSynchCode"].ToString() != "")
{
model.BussSynchCode = new Guid(ds.Tables[0].Rows[0]["BussSynchCode"].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]["IsRecommend"].ToString() != "")
{
model.IsRecommend = int.Parse(ds.Tables[0].Rows[0]["IsRecommend"].ToString());
}
model.RecommendIndex = ds.Tables[0].Rows[0]["RecommendIndex"].ToString();
model.RecommendTitle = ds.Tables[0].Rows[0]["RecommendTitle"].ToString();
model.RecommendContent = ds.Tables[0].Rows[0]["RecommendContent"].ToString();
model.ImgLogo1 = ds.Tables[0].Rows[0]["ImgLogo1"].ToString();
model.ImgLogo2 = ds.Tables[0].Rows[0]["ImgLogo2"].ToString();
model.ImgLogo3 = ds.Tables[0].Rows[0]["ImgLogo3"].ToString();
model.ImgLogo4 = ds.Tables[0].Rows[0]["ImgLogo4"].ToString();
model.ImgLogo5 = ds.Tables[0].Rows[0]["ImgLogo5"].ToString();
model.ImgLogo6 = ds.Tables[0].Rows[0]["ImgLogo6"].ToString();
model.ImgLogo7 = ds.Tables[0].Rows[0]["ImgLogo7"].ToString();
model.ImgLogo8 = ds.Tables[0].Rows[0]["ImgLogo8"].ToString();
model.ImgLogo9 = ds.Tables[0].Rows[0]["ImgLogo9"].ToString();
model.ImgLogo10 = ds.Tables[0].Rows[0]["ImgLogo10"].ToString();
if (ds.Tables[0].Rows[0]["VisitCount"].ToString() != "")
{
model.VisitCount = int.Parse(ds.Tables[0].Rows[0]["VisitCount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
