/// <summary> /// 设置读者级别 /// </summary> /// <param name="i">1代表修改</param> /// <param name="su"></param> /// <returns></returns> public static string sysSetUp(int i, Model.SetUp su) { string str = "prco_ReadStandardSave"; SqlParameter[] Parameter = { new SqlParameter("@num", SqlDbType.Int), new SqlParameter("@读者级别", SqlDbType.Int), new SqlParameter("@可借天数", SqlDbType.Int), new SqlParameter("@可借最高级别", SqlDbType.Int), new SqlParameter("@可借本数", SqlDbType.Int), new SqlParameter("@backvalue", SqlDbType.NVarChar, 20) }; Parameter[0].Value = i; Parameter[1].Value = su.CbReadLevel; Parameter[2].Value = su.NudReadDateNum; Parameter[3].Value = su.CbReadMaxLevel; Parameter[4].Value = su.NudBookNum; Parameter[5].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter); return(Convert.ToString(Parameter[5].Value.ToString())); }
//-------------------------------------------------------------------------------------------------- //罚款确定 private void btnFineOk_Click(object sender, EventArgs e) { try { Model.SetUp su = new Model.SetUp(); su.TbFineBook = Convert.ToDecimal(this.tbFineBook.Text); su.TbFineDate = Convert.ToDecimal(this.tbFineDate.Text); su.TbFineLost = Convert.ToInt32(this.tbFineLost.Value); BLL.SetUpBLL.sysFine(1, su); //关闭窗体 this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//罚款应用 private void btnFineApp_Click(object sender, EventArgs e) { try { this.btnFineApp.Enabled = false; Model.SetUp su = new Model.SetUp(); su.TbFineBook = Convert.ToDecimal(this.tbFineBook.Text); su.TbFineDate = Convert.ToDecimal(this.tbFineDate.Text); su.TbFineLost = Convert.ToInt32(this.tbFineLost.Value); string a = BLL.SetUpBLL.sysFine(1, su); MessageBox.Show(a, "提示"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//确定 private void btnSetUpOK_Click(object sender, EventArgs e) { try { Model.SetUp su = new Model.SetUp(); su.CbReadLevel = Convert.ToInt32(this.cbReadLevel.Text); su.NudReadDateNum = Convert.ToInt32(this.nudReadDateNum.Value); su.CbReadMaxLevel = Convert.ToInt32(this.cbReadMaxLevel.Text); su.NudBookNum = Convert.ToInt32(this.nudBookNum.Value); BLL.SetUpBLL.sysSetUp(1, su); //关闭窗体 this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//应用 private void btnSetUpApp_Click(object sender, EventArgs e) { try { //禁用 this.btnSetUpApp.Enabled = false; Model.SetUp su = new Model.SetUp(); //实体类 封装数据 su.CbReadLevel = Convert.ToInt32(this.cbReadLevel.Text); su.NudReadDateNum = Convert.ToInt32(this.nudReadDateNum.Value); su.CbReadMaxLevel = Convert.ToInt32(this.cbReadMaxLevel.Text); su.NudBookNum = Convert.ToInt32(this.nudBookNum.Value); string a = BLL.SetUpBLL.sysSetUp(1, su); //业务处理层 返回处理完的值 MessageBox.Show(a, "提示"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 设置罚款单价 /// </summary> /// <param name="i">1代表修改</param> /// <param name="su"></param> /// <returns></returns> public static string sysFine(int i, Model.SetUp su) { string str = "proc_FineStandardSave"; SqlParameter[] Parameter = { new SqlParameter("@num", SqlDbType.Int), new SqlParameter("@逾期单价", SqlDbType.Decimal), new SqlParameter("@损坏单价", SqlDbType.Decimal), new SqlParameter("@丢失单价", SqlDbType.TinyInt), new SqlParameter("@backvalue", SqlDbType.NVarChar, 20) }; Parameter[0].Value = i; Parameter[1].Value = su.TbFineDate; Parameter[2].Value = su.TbFineBook; Parameter[3].Value = su.TbFineLost; Parameter[4].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter); return(Convert.ToString(Parameter[4].Value.ToString())); }