/// <summary> /// 导入行数据插入到数据库 /// </summary> /// <param name="model"></param> /// <param name="transaction"></param> private void EmportRowInsert(ModProhibited model, SqlTransaction transaction) { //insert语句 string sql = @"insert into prohibitedgood(type, pname, premark, created, created_time) values(@type, @pname, @premark, @created, getdate())"; //参数数组 SqlParameter[] _params = new SqlParameter[] { new SqlParameter("@type", model.Type), new SqlParameter("@pname", model.PName), new SqlParameter("@premark", model.PRemark), new SqlParameter("@created", model.Created) }; //执行插入操作 SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, sql, _params); }
/// <summary> /// 导入行数据更新到数据库 /// </summary> /// <param name="model"></param> /// <param name="transaction"></param> private void EmportRowUpdate(ModProhibited model, SqlTransaction transaction) { //update语句 string sql = @"update prohibitedgood set type = @type, pname = @pname, premark = @premark, updated = @updated, updated_time = getdate() where pid = @pid"; //参数数组 SqlParameter[] _params = new SqlParameter[] { new SqlParameter("@type", model.Type), new SqlParameter("@pname", model.PName), new SqlParameter("@premark", model.PRemark), new SqlParameter("@updated", model.Updated), new SqlParameter("@pid", model.Pid) }; //执行更新操作 SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, sql, _params); }
/// <summary> /// 判断数据库中禁运物品名称是否已存在 /// </summary> /// <param name="model"></param> /// <param name="transaction"></param> /// <returns></returns> private int EmportRowIsRepeat(ModProhibited model, SqlTransaction transaction) { //不为空时, 禁运物品名称 数据库是否已存在 string strSql = string.Format("select top 1 pid from prohibitedgood where type = {0} and pname = '{1}'", model.Type, model.PName.Trim()); object result = SQLHelper.ExecuteScalar(transaction, CommandType.Text, strSql, null); //返回对应记录ID if (null == result) { return(0); } else { return(Convert.ToInt32(result)); } }