/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SDAU.ZHCZ.Model.LvYouGuiHuaXinXi model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LvYouGuiHuaXinXi(");
strSql.Append("GHXMBianHao,GHXMMingCheng, GHXMJieShao,GuiHuaFanWei,GuiHuaMianJi,GuiHuaNianXian,GuiHuaMuBiao,GuiHuaRenWu,GuiHuaTu,GuiHuaShiJian,GuiHuaDanWei,FuZeRen,BeiZhu,JingDu,WeiDu)");
strSql.Append(" values (");
strSql.Append("@GHXMBianHao,@GHXMMingCheng,@GHXMJieShao,@GuiHuaFanWei,@GuiHuaMianJi,@GuiHuaNianXian,@GuiHuaMuBiao,@GuiHuaRenWu,@GuiHuaTu,@GuiHuaShiJian,@GuiHuaDanWei,@FuZeRen,@BeiZhu,@JingDu,@Weidu)");
SqlParameter[] parameters =
{
new SqlParameter("@GHXMBianHao", SqlDbType.NChar, 12),
new SqlParameter("@GHXMMingCheng", SqlDbType.NVarChar, 50),
new SqlParameter("@GHXMJieShao", SqlDbType.NVarChar, 500),
new SqlParameter("@GuiHuaFanWei", SqlDbType.NVarChar, 50),
new SqlParameter("@GuiHuaMianJi", SqlDbType.NVarChar, 20),
new SqlParameter("@GuiHuaNianXian", SqlDbType.NVarChar, 50),
new SqlParameter("@GuiHuaMuBiao", SqlDbType.NVarChar, 300),
new SqlParameter("@GuiHuaRenWu", SqlDbType.NVarChar, 300),
new SqlParameter("@GuiHuaTu", SqlDbType.NVarChar, 1000),
new SqlParameter("@GuiHuaShiJian", SqlDbType.DateTime),
new SqlParameter("@GuiHuaDanWei", SqlDbType.NVarChar, 20),
new SqlParameter("@FuZeRen", SqlDbType.NVarChar, 20),
new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 200),
new SqlParameter("@JingDu", SqlDbType.NVarChar, 10),
new SqlParameter("@WeiDu", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.GHXMBianHao;
parameters[1].Value = model.GHXMMingCheng;
parameters[2].Value = model.GHXMJieShao;
parameters[3].Value = model.GuiHuaFanWei;
parameters[4].Value = model.GuiHuaMianJi;
parameters[5].Value = model.GuiHuaNianXian;
parameters[6].Value = model.GuiHuaMuBiao;
parameters[7].Value = model.GuiHuaRenWu;
parameters[8].Value = model.GuiHuaTu;
parameters[9].Value = model.GuiHuaShiJian;
parameters[10].Value = model.GuiHuaDanWei;
parameters[11].Value = model.FuZeRen;
parameters[12].Value = model.BeiZhu;
parameters[13].Value = model.JingDu;
parameters[14].Value = model.WeiDu;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SDAU.ZHCZ.Model.LvYouGuiHuaXinXi model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update LvYouGuiHuaXinXi set ");
strSql.Append("GHXMJieShao=@GHXMJieShao,");
strSql.Append("GuiHuaFanWei=@GuiHuaFanWei,");
strSql.Append("GuiHuaMianJi=@GuiHuaMianJi,");
strSql.Append("GuiHuaNianXian=@GuiHuaNianXian,");
strSql.Append("GuiHuaMuBiao=@GuiHuaMuBiao,");
strSql.Append("GuiHuaRenWu=@GuiHuaRenWu,");
strSql.Append("GuiHuaTu=@GuiHuaTu,");
strSql.Append("FuZeRen=@FuZeRen,");
strSql.Append("GuiHuaDanWei=@GuiHuaDanWei,");
strSql.Append("GHXMMingCheng=@GHXMMingCheng,");
strSql.Append("GuiHuaShiJian=@GuiHuaShiJian,");
strSql.Append("BeiZhu=@BeiZhu");
strSql.Append("JingDu=@JingDu");
strSql.Append("WeiDu=@WeiDu");
strSql.Append(" where GHXMBianHao=@GHXMBianHao ");
SqlParameter[] parameters =
{
new SqlParameter("@GHXMJieShao", SqlDbType.NVarChar, 500),
new SqlParameter("@GuiHuaFanWei", SqlDbType.NVarChar, 50),
new SqlParameter("@GuiHuaMianJi", SqlDbType.NVarChar, 20),
new SqlParameter("@GuiHuaNianXian", SqlDbType.NVarChar, 50),
new SqlParameter("@GuiHuaMuBiao", SqlDbType.NVarChar, 300),
new SqlParameter("@GuiHuaRenWu", SqlDbType.NVarChar, 300),
new SqlParameter("@GuiHuaTu", SqlDbType.NVarChar, 1000),
new SqlParameter("@FuZeRen", SqlDbType.NVarChar, 20),
new SqlParameter("@GHXMBianHao", SqlDbType.NChar, 12),
new SqlParameter("@GHXMMingCheng", SqlDbType.NVarChar, 50),
new SqlParameter("@GuiHuaShiJian", SqlDbType.DateTime),
new SqlParameter("@GuiHuaDanWei", SqlDbType.NVarChar, 20),
new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 200),
new SqlParameter("@JingDu", SqlDbType.NVarChar, 10),
new SqlParameter("@WeiDu", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.GHXMJieShao;
parameters[1].Value = model.GuiHuaFanWei;
parameters[2].Value = model.GuiHuaMianJi;
parameters[3].Value = model.GuiHuaNianXian;
parameters[4].Value = model.GuiHuaMuBiao;
parameters[5].Value = model.GuiHuaRenWu;
parameters[6].Value = model.GuiHuaTu;
parameters[7].Value = model.FuZeRen;
parameters[8].Value = model.GHXMBianHao;
parameters[9].Value = model.GHXMMingCheng;
parameters[10].Value = model.GuiHuaShiJian;
parameters[11].Value = model.GuiHuaDanWei;
parameters[12].Value = model.BeiZhu;
parameters[13].Value = model.JingDu;
parameters[14].Value = model.WeiDu;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SDAU.ZHCZ.Model.LvYouGuiHuaXinXi DataRowToModel(DataRow row)
{
SDAU.ZHCZ.Model.LvYouGuiHuaXinXi model = new SDAU.ZHCZ.Model.LvYouGuiHuaXinXi();
if (row != null)
{
if (row["GHXMBianHao"] != null)
{
model.GHXMBianHao = row["GHXMBianHao"].ToString();
}
if (row["GHXMMingCheng"] != null)
{
model.GHXMMingCheng = row["GHXMMingCheng"].ToString();
}
if (row["GHXMJieShao"] != null)
{
model.GHXMJieShao = row["GHXMJieShao"].ToString();
}
if (row["GuiHuaFanWei"] != null)
{
model.GuiHuaFanWei = row["GuiHuaFanWei"].ToString();
}
if (row["GuiHuaMianJi"] != null)
{
model.GuiHuaMianJi = row["GuiHuaMianJi"].ToString();
}
if (row["GuiHuaNianXian"] != null)
{
model.GuiHuaNianXian = row["GuiHuaNianXian"].ToString();
}
if (row["GuiHuaMuBiao"] != null)
{
model.GuiHuaMuBiao = row["GuiHuaMuBiao"].ToString();
}
if (row["GuiHuaRenWu"] != null)
{
model.GuiHuaRenWu = row["GuiHuaRenWu"].ToString();
}
if (row["GuiHuaTu"] != null && row["GuiHuaTu"].ToString() != "")
{
model.GuiHuaTu = row["GuiHuaTu"].ToString();
}
if (row["GuiHuaShiJian"] != null && row["GuiHuaShiJian"].ToString() != "")
{
model.GuiHuaShiJian = DateTime.Parse(row["GuiHuaShiJian"].ToString());
}
if (row["GuiHuaDanWei"] != null)
{
model.GuiHuaDanWei = row["GuiHuaDanWei"].ToString();
}
if (row["FuZeRen"] != null)
{
model.FuZeRen = row["FuZeRen"].ToString();
}
if (row["BeiZhu"] != null)
{
model.BeiZhu = row["BeiZhu"].ToString();
}
if (row["JingDu"] != null)
{
model.JingDu = row["JingDu"].ToString();
}
if (row["WeiDu"] != null)
{
model.WeiDu = row["WeiDu"].ToString();
}
}
return(model);
}
