/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_queue model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_queue set "); strSql.Append(" q_order_code = @q_order_code , "); strSql.Append(" q_bizcode = @q_bizcode , "); strSql.Append(" q_address = @q_address , "); strSql.Append(" q_noticestate = @q_noticestate , "); strSql.Append(" q_times = @q_times , "); strSql.Append(" q_noticetimes = @q_noticetimes , "); strSql.Append(" q_sign = @q_sign , "); strSql.Append(" q_tablename = @q_tablename, "); strSql.Append(" q_privateinfo = @q_privateinfo "); strSql.Append(" where q_id=@q_id "); SqlParameter[] parameters = { new SqlParameter("@q_id", SqlDbType.Int, 4), new SqlParameter("@q_order_code", SqlDbType.NVarChar, -1), new SqlParameter("@q_bizcode", SqlDbType.NVarChar, -1), new SqlParameter("@q_address", SqlDbType.NVarChar, -1), new SqlParameter("@q_noticestate", SqlDbType.Int, 4), new SqlParameter("@q_times", SqlDbType.Int, 4), new SqlParameter("@q_noticetimes", SqlDbType.DateTime), new SqlParameter("@q_tablename", SqlDbType.NVarChar, -1), new SqlParameter("@q_sign", SqlDbType.NVarChar, -1), new SqlParameter("@q_privateinfo", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.q_id; parameters[1].Value = model.q_order_code; parameters[2].Value = model.q_bizcode; parameters[3].Value = model.q_address; parameters[4].Value = model.q_noticestate; parameters[5].Value = model.q_times; parameters[6].Value = model.q_noticetimes; parameters[7].Value = model.q_tablename; parameters[8].Value = model.q_sign; parameters[9].Value = model.q_privateinfo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_queue GetModel(int q_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select q_id, q_order_code, q_bizcode, q_address, q_noticestate, q_times, q_noticetimes, q_tablename ,q_sign,q_privateinfo "); strSql.Append(" from jmp_queue "); strSql.Append(" where q_id=@q_id"); SqlParameter[] parameters = { new SqlParameter("@q_id", SqlDbType.Int, 4) }; parameters[0].Value = q_id; JMP.MDL.jmp_queue model = new JMP.MDL.jmp_queue(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["q_id"].ToString() != "") { model.q_id = int.Parse(ds.Tables[0].Rows[0]["q_id"].ToString()); } model.q_order_code = ds.Tables[0].Rows[0]["q_order_code"].ToString(); model.q_bizcode = ds.Tables[0].Rows[0]["q_bizcode"].ToString(); model.q_address = ds.Tables[0].Rows[0]["q_address"].ToString(); if (ds.Tables[0].Rows[0]["q_noticestate"].ToString() != "") { model.q_noticestate = int.Parse(ds.Tables[0].Rows[0]["q_noticestate"].ToString()); } if (ds.Tables[0].Rows[0]["q_times"].ToString() != "") { model.q_times = int.Parse(ds.Tables[0].Rows[0]["q_times"].ToString()); } if (ds.Tables[0].Rows[0]["q_noticetimes"].ToString() != "") { model.q_noticetimes = DateTime.Parse(ds.Tables[0].Rows[0]["q_noticetimes"].ToString()); } model.q_tablename = ds.Tables[0].Rows[0]["q_tablename"].ToString(); model.q_sign = ds.Tables[0].Rows[0]["q_sign"].ToString(); model.q_privateinfo = ds.Tables[0].Rows[0]["q_privateinfo"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_queue model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_queue("); strSql.Append("q_order_code,q_bizcode,q_address,q_noticestate,q_times,q_noticetimes,q_tablename,q_sign,q_privateinfo"); strSql.Append(") values ("); strSql.Append("@q_order_code,@q_bizcode,@q_address,@q_noticestate,@q_times,@q_noticetimes,@q_tablename,@q_sign,@q_privateinfo"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@q_order_code", SqlDbType.NVarChar, -1), new SqlParameter("@q_bizcode", SqlDbType.NVarChar, -1), new SqlParameter("@q_address", SqlDbType.NVarChar, -1), new SqlParameter("@q_noticestate", SqlDbType.Int, 4), new SqlParameter("@q_times", SqlDbType.Int, 4), new SqlParameter("@q_noticetimes", SqlDbType.DateTime), new SqlParameter("@q_tablename", SqlDbType.NVarChar, -1), new SqlParameter("@q_sign", SqlDbType.NVarChar, -1), new SqlParameter("@q_privateinfo", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.q_order_code; parameters[1].Value = model.q_bizcode; parameters[2].Value = model.q_address; parameters[3].Value = model.q_noticestate; parameters[4].Value = model.q_times; parameters[5].Value = model.q_noticetimes; parameters[6].Value = model.q_tablename; parameters[7].Value = model.q_sign; parameters[8].Value = model.q_privateinfo; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }