/// <summary> /// 得到一个对象实体 /// </summary> public jdgl_res_head_app.Model.MT_Order GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,channel_id,category_id,order_lsbh,user_id,fjrx_id,yd_name,yd_sex,yd_mobile,yd_email,crs,xhrs,yd_ddsj,yd_js,content,yd_ts,yd_jg,yd_statetime,yd_endtime,is_rz,state,add_time from MT_Order "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; jdgl_res_head_app.Model.MT_Order model = new jdgl_res_head_app.Model.MT_Order(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(jdgl_res_head_app.Model.MT_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MT_Order("); strSql.Append("channel_id,category_id,order_lsbh,user_id,fjrx_id,yd_name,yd_sex,yd_mobile,yd_email,crs,xhrs,yd_ddsj,yd_js,content,yd_ts,yd_jg,yd_statetime,yd_endtime,is_rz,state,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@category_id,@order_lsbh,@user_id,@fjrx_id,@yd_name,@yd_sex,@yd_mobile,@yd_email,@crs,@xhrs,@yd_ddsj,@yd_js,@content,@yd_ts,@yd_jg,@yd_statetime,@yd_endtime,@is_rz,@state,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@category_id", SqlDbType.Int, 4), new SqlParameter("@order_lsbh", SqlDbType.NVarChar, 150), new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@fjrx_id", SqlDbType.Int, 4), new SqlParameter("@yd_name", SqlDbType.NVarChar, 150), new SqlParameter("@yd_sex", SqlDbType.NVarChar, 50), new SqlParameter("@yd_mobile", SqlDbType.NVarChar, 150), new SqlParameter("@yd_email", SqlDbType.NVarChar, 150), new SqlParameter("@crs", SqlDbType.Int, 4), new SqlParameter("@xhrs", SqlDbType.Int, 4), new SqlParameter("@yd_ddsj", SqlDbType.VarChar, 50), new SqlParameter("@yd_js", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@yd_ts", SqlDbType.Decimal, 9), new SqlParameter("@yd_jg", SqlDbType.Decimal, 9), new SqlParameter("@yd_statetime", SqlDbType.DateTime), new SqlParameter("@yd_endtime", SqlDbType.DateTime), new SqlParameter("@is_rz", SqlDbType.Int, 4), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime) }; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.order_lsbh; parameters[3].Value = model.user_id; parameters[4].Value = model.fjrx_id; parameters[5].Value = model.yd_name; parameters[6].Value = model.yd_sex; parameters[7].Value = model.yd_mobile; parameters[8].Value = model.yd_email; parameters[9].Value = model.crs; parameters[10].Value = model.xhrs; parameters[11].Value = model.yd_ddsj; parameters[12].Value = model.yd_js; parameters[13].Value = model.content; parameters[14].Value = model.yd_ts; parameters[15].Value = model.yd_jg; parameters[16].Value = model.yd_statetime; parameters[17].Value = model.yd_endtime; parameters[18].Value = model.is_rz; parameters[19].Value = model.state; parameters[20].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public jdgl_res_head_app.Model.MT_Order DataRowToModel(DataRow row) { jdgl_res_head_app.Model.MT_Order model = new jdgl_res_head_app.Model.MT_Order(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["channel_id"] != null && row["channel_id"].ToString() != "") { model.channel_id = int.Parse(row["channel_id"].ToString()); } if (row["category_id"] != null && row["category_id"].ToString() != "") { model.category_id = int.Parse(row["category_id"].ToString()); } if (row["order_lsbh"] != null) { model.order_lsbh = row["order_lsbh"].ToString(); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["fjrx_id"] != null && row["fjrx_id"].ToString() != "") { model.fjrx_id = int.Parse(row["fjrx_id"].ToString()); } if (row["yd_name"] != null) { model.yd_name = row["yd_name"].ToString(); } if (row["yd_sex"] != null) { model.yd_sex = row["yd_sex"].ToString(); } if (row["yd_mobile"] != null) { model.yd_mobile = row["yd_mobile"].ToString(); } if (row["yd_email"] != null) { model.yd_email = row["yd_email"].ToString(); } if (row["crs"] != null && row["crs"].ToString() != "") { model.crs = int.Parse(row["crs"].ToString()); } if (row["xhrs"] != null && row["xhrs"].ToString() != "") { model.xhrs = int.Parse(row["xhrs"].ToString()); } if (row["yd_ddsj"] != null) { model.yd_ddsj = row["yd_ddsj"].ToString(); } if (row["yd_js"] != null && row["yd_js"].ToString() != "") { model.yd_js = int.Parse(row["yd_js"].ToString()); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["yd_ts"] != null && row["yd_ts"].ToString() != "") { model.yd_ts = decimal.Parse(row["yd_ts"].ToString()); } if (row["yd_jg"] != null && row["yd_jg"].ToString() != "") { model.yd_jg = decimal.Parse(row["yd_jg"].ToString()); } if (row["yd_statetime"] != null && row["yd_statetime"].ToString() != "") { model.yd_statetime = DateTime.Parse(row["yd_statetime"].ToString()); } if (row["yd_endtime"] != null && row["yd_endtime"].ToString() != "") { model.yd_endtime = DateTime.Parse(row["yd_endtime"].ToString()); } if (row["is_rz"] != null && row["is_rz"].ToString() != "") { model.is_rz = int.Parse(row["is_rz"].ToString()); } if (row["state"] != null && row["state"].ToString() != "") { model.state = int.Parse(row["state"].ToString()); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = DateTime.Parse(row["add_time"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(jdgl_res_head_app.Model.MT_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MT_Order set "); strSql.Append("channel_id=@channel_id,"); strSql.Append("category_id=@category_id,"); strSql.Append("order_lsbh=@order_lsbh,"); strSql.Append("user_id=@user_id,"); strSql.Append("fjrx_id=@fjrx_id,"); strSql.Append("yd_name=@yd_name,"); strSql.Append("yd_sex=@yd_sex,"); strSql.Append("yd_mobile=@yd_mobile,"); strSql.Append("yd_email=@yd_email,"); strSql.Append("crs=@crs,"); strSql.Append("xhrs=@xhrs,"); strSql.Append("yd_ddsj=@yd_ddsj,"); strSql.Append("yd_js=@yd_js,"); strSql.Append("content=@content,"); strSql.Append("yd_ts=@yd_ts,"); strSql.Append("yd_jg=@yd_jg,"); strSql.Append("yd_statetime=@yd_statetime,"); strSql.Append("yd_endtime=@yd_endtime,"); strSql.Append("is_rz=@is_rz,"); strSql.Append("state=@state,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@category_id", SqlDbType.Int, 4), new SqlParameter("@order_lsbh", SqlDbType.NVarChar, 150), new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@fjrx_id", SqlDbType.Int, 4), new SqlParameter("@yd_name", SqlDbType.NVarChar, 150), new SqlParameter("@yd_sex", SqlDbType.NVarChar, 50), new SqlParameter("@yd_mobile", SqlDbType.NVarChar, 150), new SqlParameter("@yd_email", SqlDbType.NVarChar, 150), new SqlParameter("@crs", SqlDbType.Int, 4), new SqlParameter("@xhrs", SqlDbType.Int, 4), new SqlParameter("@yd_ddsj", SqlDbType.VarChar, 50), new SqlParameter("@yd_js", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@yd_ts", SqlDbType.Decimal, 9), new SqlParameter("@yd_jg", SqlDbType.Decimal, 9), new SqlParameter("@yd_statetime", SqlDbType.DateTime), new SqlParameter("@yd_endtime", SqlDbType.DateTime), new SqlParameter("@is_rz", SqlDbType.Int, 4), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.order_lsbh; parameters[3].Value = model.user_id; parameters[4].Value = model.fjrx_id; parameters[5].Value = model.yd_name; parameters[6].Value = model.yd_sex; parameters[7].Value = model.yd_mobile; parameters[8].Value = model.yd_email; parameters[9].Value = model.crs; parameters[10].Value = model.xhrs; parameters[11].Value = model.yd_ddsj; parameters[12].Value = model.yd_js; parameters[13].Value = model.content; parameters[14].Value = model.yd_ts; parameters[15].Value = model.yd_jg; parameters[16].Value = model.yd_statetime; parameters[17].Value = model.yd_endtime; parameters[18].Value = model.is_rz; parameters[19].Value = model.state; parameters[20].Value = model.add_time; parameters[21].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }