/// <summary> /// 更新一条数据 /// </summary> public bool Update(SDAU.ZHCZ.Model.LvYouJingDianXinXi model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LvYouJingDianXinXi set "); strSql.Append("JDJieShao=@JDJieShao,"); strSql.Append("JDWeiZhi=@JDWeiZhi,"); strSql.Append("JingDu=@JingDu,"); strSql.Append("WeiDu=@WeiDu,"); strSql.Append("TuPian=@TuPian,"); strSql.Append("LiuLanCiShu=@LiuLanCiShu,"); strSql.Append("FBShiJian=@FBShiJian,"); strSql.Append("BeiZhu=@BeiZhu"); strSql.Append(" where JDBianHao=@JDBianHao"); SqlParameter[] parameters = { new SqlParameter("@JDJieShao", SqlDbType.NVarChar, 50000), new SqlParameter("@JDWeiZhi", SqlDbType.NVarChar, 50), new SqlParameter("@JingDu", SqlDbType.NVarChar, 10), new SqlParameter("@WeiDu", SqlDbType.NVarChar, 10), new SqlParameter("@TuPian", SqlDbType.NVarChar, 1000), new SqlParameter("@LiuLanCiShu", SqlDbType.Int, 4), new SqlParameter("@FBShiJian", SqlDbType.DateTime), new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 200), new SqlParameter("@JDBianHao", SqlDbType.Int, 4), new SqlParameter("@JDMingCheng", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.JDJieShao; parameters[1].Value = model.JDWeiZhi; parameters[2].Value = model.JingDu; parameters[3].Value = model.WeiDu; parameters[4].Value = model.TuPian; parameters[5].Value = model.LiuLanCiShu; parameters[6].Value = model.FBShiJian; parameters[7].Value = model.BeiZhu; parameters[8].Value = model.JDBianHao; parameters[9].Value = model.JDMingCheng; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SDAU.ZHCZ.Model.LvYouJingDianXinXi DataRowToModel(DataRow row) { SDAU.ZHCZ.Model.LvYouJingDianXinXi model = new SDAU.ZHCZ.Model.LvYouJingDianXinXi(); if (row != null) { if (row["JDBianHao"] != null && row["JDBianHao"].ToString() != "") { model.JDBianHao = int.Parse(row["JDBianHao"].ToString()); } if (row["JDMingCheng"] != null) { model.JDMingCheng = row["JDMingCheng"].ToString(); } if (row["JDJieShao"] != null) { model.JDJieShao = row["JDJieShao"].ToString(); } if (row["JDWeiZhi"] != null) { model.JDWeiZhi = row["JDWeiZhi"].ToString(); } if (row["JingDu"] != null) { model.JingDu = row["JingDu"].ToString(); } if (row["WeiDu"] != null) { model.WeiDu = row["WeiDu"].ToString(); } if (row["TuPian"] != null && row["TuPian"].ToString() != "") { model.TuPian = row["TuPian"].ToString(); } if (row["LiuLanCiShu"] != null && row["LiuLanCiShu"].ToString() != "") { model.LiuLanCiShu = int.Parse(row["LiuLanCiShu"].ToString()); } if (row["FBShiJian"] != null && row["FBShiJian"].ToString() != "") { model.FBShiJian = DateTime.Parse(row["FBShiJian"].ToString()); } if (row["BeiZhu"] != null) { model.BeiZhu = row["BeiZhu"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SDAU.ZHCZ.Model.LvYouJingDianXinXi model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LvYouJingDianXinXi("); strSql.Append("JDMingCheng,JDJieShao,JDWeiZhi,JingDu,WeiDu,TuPian,LiuLanCiShu,FBShiJian,BeiZhu)"); strSql.Append(" values ("); strSql.Append("@JDMingCheng,@JDJieShao,@JDWeiZhi,@JingDu,@WeiDu,@TuPian,@LiuLanCiShu,@FBShiJian,@BeiZhu)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@JDMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@JDJieShao", SqlDbType.NVarChar, 50000), new SqlParameter("@JDWeiZhi", SqlDbType.NVarChar, 50), new SqlParameter("@JingDu", SqlDbType.NVarChar, 10), new SqlParameter("@WeiDu", SqlDbType.NVarChar, 10), new SqlParameter("@TuPian", SqlDbType.NVarChar, 1000), new SqlParameter("@LiuLanCiShu", SqlDbType.Int, 4), new SqlParameter("@FBShiJian", SqlDbType.DateTime), new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.JDMingCheng; parameters[1].Value = model.JDJieShao; parameters[2].Value = model.JDWeiZhi; parameters[3].Value = model.JingDu; parameters[4].Value = model.WeiDu; parameters[5].Value = model.TuPian; parameters[6].Value = model.LiuLanCiShu; parameters[7].Value = model.FBShiJian; parameters[8].Value = model.BeiZhu; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SDAU.ZHCZ.Model.LvYouJingDianXinXi GetModel(string JDMingCheng) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 JDBianHao,JDMingCheng,JDJieShao,JDWeiZhi,JingDu,WeiDu,TuPian,LiuLanCiShu,FBShiJian,BeiZhu from LvYouJingDianXinXi "); strSql.Append(" where JDMingCheng=@JDMingCheng"); SqlParameter[] parameters = { new SqlParameter("@JDMingCheng", SqlDbType.NVarChar, 50) }; parameters[0].Value = JDMingCheng; SDAU.ZHCZ.Model.LvYouJingDianXinXi model = new SDAU.ZHCZ.Model.LvYouJingDianXinXi(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }