public BillsType SelectBillsType(int id, IDbConnection conn) { string sql = @" select ID,Code,Name,IsOut,Actived,Remark from MD_BillsType where ID=@ID"; List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@ID", id)); SqlDataReader reader = DataAccessUtil.ExecuteReader(sql, paramList, (SqlConnection)conn); BillsType type = null; while (reader.Read()) { type = new BillsType(); type.ID = reader.GetInt32(0); type.Code = reader.GetString(1); type.Name = reader.GetString(2); type.IsOut = reader.GetBoolean(3); type.Actived = reader.GetBoolean(4); if (!reader.IsDBNull(5)) { type.Remark = reader.GetString(5); } } reader.Close(); return(type); }
/// <summary> /// 删除一条票据类型信息 /// </summary> /// <param name="id"></param> /// <param name="deleter"></param> public void DeleteBillsType(BillsType billsType, string deleter) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO(); dao.DeleteBillsType(billsType.ID, conn); } }
/// <summary> /// 保存修改过的票据类型信息 /// </summary> /// <param name="type"></param> /// <param name="Modifier"></param> public void SaveBillsType(BillsType type, string Modifier) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO(); dao.UpdateBillsType(type, conn); } }
/// <summary> /// 新增一条票据类别 /// </summary> /// <param name="type"></param> /// <param name="creator"></param> public void CreateBillsType(BillsType type, string creator) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO(); dao.InsertBillsType(type, conn); } }
/// <summary> /// 用于修改 /// </summary> /// <param name="model"></param> public FrmBillsType(BillsType model) { InitializeComponent(); this.Text = string.Format(this.Text, "修改类别"); this.Model = model; this.txtCode.Text = model.Code; this.txtName.Text = model.Name; this.ckbIsOut.Checked = model.IsOut; this.ckbActived.Checked = model.Actived; this.txtRemark.Text = model.Remark; }
public void EditData(BillsType model) { model.UserId = CookieHelper.UserId.ToInt32(); if (model.Id <= 0) { commonbll.Insert(model); } else { commonbll.Update(model); } }
public void InsertBillsType(BillsType type, IDbConnection conn, IDbTransaction trans) { string sql = @" Insert into MD_BillsType(Code,Name,IsOut,Actived,Remark) values(@Code,@Name,@IsOut,@Actived,@Remark) "; List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@Code", type.Code)); paramList.Add(new SqlParameter("@Name", type.Name)); paramList.Add(new SqlParameter("@IsOut", type.IsOut)); paramList.Add(new SqlParameter("@Actived", type.Actived)); paramList.Add(new SqlParameter("@Remark", type.Remark)); DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans); }
public void UpdateBillsType(BillsType type, IDbConnection conn, IDbTransaction trans) { string sql = @" Update MD_BillsType set Code=@Code,Name=@Name,IsOut=@IsOut,Actived=@Actived,Remark=@Remark where ID=@ID"; List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@Code", type.Code)); paramList.Add(new SqlParameter("@Name", type.Name)); paramList.Add(new SqlParameter("@IsOut", type.IsOut)); paramList.Add(new SqlParameter("@Actived", type.Actived)); paramList.Add(new SqlParameter("@Remark", type.Remark)); paramList.Add(new SqlParameter("@ID", type.ID)); DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans); }
private List <BillsType> GetSelectModelList() { List <BillsType> selectedModelList = new List <BillsType>(); foreach (DataGridViewRow row in dataGridView1.Rows) { DataGridViewCheckBoxCell cell = (DataGridViewCheckBoxCell)row.Cells[0]; if (cell.EditedFormattedValue != null && (bool)cell.EditedFormattedValue == true) { BillsType selectedModel = (BillsType)row.Tag; selectedModelList.Add(selectedModel); } } if (selectedModelList.Count == 0) { throw new ApplicationException("请选择要操作的内容。"); } return(selectedModelList); }
private void btnOK_Click(object sender, EventArgs e) { try { //Verify if (string.IsNullOrEmpty(this.txtCode.Text.Trim())) { throw new ApplicationException("编码不能为空"); } if (string.IsNullOrEmpty(this.txtName.Text.Trim())) { throw new ApplicationException("名称不能为空"); } //save ModelService modelService = new ModelService(); if (this.Model == null)//新建 { BillsType model = new BillsType(); model.Code = this.txtCode.Text.Trim(); model.Name = this.txtName.Text.Trim(); model.IsOut = this.ckbIsOut.Checked; model.Actived = this.ckbActived.Checked; model.Remark = this.txtRemark.Text.Trim(); modelService.CreateBillsType(model, PermissionService.GetCurrentUser().Name); } else//修改 { this.Model.Code = this.txtCode.Text.Trim(); this.Model.Name = this.txtName.Text.Trim(); this.Model.IsOut = this.ckbIsOut.Checked; this.Model.Actived = this.ckbActived.Checked; this.Model.Remark = this.txtRemark.Text.Trim(); modelService.SaveBillsType(this.Model, PermissionService.GetCurrentUser().Name); } //close diaglog this.DialogResult = DialogResult.OK; } catch (Exception ex) { ErrorHandler.OnError(ex); } }
public BillsType GetBillsType(string billsTypeName) { if (_AllBillsType == null) { _AllBillsType = GetAllBillsType(); } BillsType billsType = null; foreach (BillsType item in _AllBillsType) { if (item.Name == billsTypeName) { billsType = item; } } if (billsType == null) { throw new ApplicationException("不存在的票据类型"); } return(billsType); }
private List <BillsType> SelectBillsType(string sql, List <SqlParameter> paramList, SqlConnection conn) { SqlDataReader reader = DataAccessUtil.ExecuteReader(sql, paramList, (SqlConnection)conn); List <BillsType> list = new List <BillsType>(); while (reader.Read()) { BillsType type = new BillsType(); type.ID = reader.GetInt32(0); type.Code = reader.GetString(1); type.Name = reader.GetString(2); type.IsOut = reader.GetBoolean(3); type.Actived = reader.GetBoolean(4); if (!reader.IsDBNull(5)) { type.Remark = reader.GetString(5); } list.Add(type); } reader.Close(); return(list); }
/// <summary> /// 根据给定的一些条件来进行票据的模糊查询 /// </summary> /// <param name="fromDate"></param> /// <param name="toDate"></param> /// <param name="companyCond"></param> /// <param name="drugsCond"></param> /// <param name="drugsFromCond"></param> /// <param name="drugsCategoryCond"></param> /// <param name="storeHouseCond"></param> /// <param name="billMaker"></param> /// <returns></returns> public List <Bills> SearchBill(DateTime fromDate, DateTime toDate, string companyCond, string drugsCond, string drugsFromCond, string drugsCategoryCond, string storeHouseCond, User billMaker, string billsID, BillsType billsType) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IBillsDAO dao = DAOFactory.Instance.CreateBillsDAO(); SearchBillsTemplate sbt = new SearchBillsTemplate(); sbt.FromDate = fromDate; sbt.ToDate = toDate; sbt.CompanyCond = companyCond; sbt.BillMaker = billMaker.Name; List <Bills> billsList = dao.SearchBills(sbt, conn); for (int i = billsList.Count - 1; i >= 0; i--) { Bills bill = billsList[i]; if (!bill.ID.ToString().Contains(billsID)) { billsList.Remove(bill); } if (!billsType.Equals(bill.BillsType)) { billsList.Remove(bill); } } return(billsList); } }
public bool Update(BillsType model) { return(commonbll.Update(model)); }
public bool Insert(BillsType model) { return(commonbll.Insert(model)); }