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