/// <summary> /// 获取发票登记信息业务实体 /// </summary> /// <param name="faPiaoId">发票登记编号</param> /// <returns></returns> public EyouSoft.Model.FinanceStructure.MFaPiaoInfo GetInfo(string faPiaoId) { EyouSoft.Model.FinanceStructure.MFaPiaoInfo info = null; DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetInfo); _db.AddInParameter(cmd, "Id", DbType.AnsiStringFixedLength, faPiaoId); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.FinanceStructure.MFaPiaoInfo(); info.BeiZhu = rdr["BeiZhu"].ToString(); info.CaoZuoRenId = rdr.GetInt32(rdr.GetOrdinal("CaoZuoRenId")); info.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")); info.CrmId = rdr.GetInt32(rdr.GetOrdinal("CrmId")); info.Id = faPiaoId; info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); info.KaiPiaoRen = rdr["KaiPiaoRen"].ToString(); info.KaiPiaoRenId = rdr.GetInt32(rdr.GetOrdinal("KaiPiaoRenId")); info.PiaoHao = rdr["PiaoHao"].ToString(); info.RiQi = rdr.GetDateTime(rdr.GetOrdinal("RiQi")); } } return(info); }
/// <summary> /// 修改开票信息,操作成功返回1 /// </summary> /// <param name="info">开票信息业务实体</param> /// <returns></returns> public int Update(EyouSoft.Model.FinanceStructure.MFaPiaoInfo info) { if (info == null || string.IsNullOrEmpty(info.Id)) { return(0); } int dalRetCode = dal.Update(info); if (dalRetCode == 1) { EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.财务管理_发票管理.ToString() + "修改开票登记,登记编号为:" + info.Id; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "修改开票登记"; logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.财务管理_发票管理; logInfo.OperatorId = 0; new EyouSoft.BLL.CompanyStructure.SysHandleLogs().Add(logInfo); } return(dalRetCode); }
/// <summary> /// 获取发票已登记列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="crmId">客户单位编号</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> GetFaPiaos(int companyId, int crmId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo) { IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> items = new List <EyouSoft.Model.FinanceStructure.MFaPiaoInfo>(); StringBuilder cmdQuery = new StringBuilder(); string tableName = "tbl_FinFaPiao"; string primaryKey = "Id"; string orderByString = "RiQi DESC"; string fields = "*"; #region SQL cmdQuery.AppendFormat(" IsDelete='0' AND CompanyId={0} AND CrmId={1} ", companyId, crmId); if (searchInfo != null) { if (searchInfo.KPETime.HasValue) { cmdQuery.AppendFormat(" AND RiQi<'{0}' ", searchInfo.KPETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(searchInfo.KPRen)) { cmdQuery.AppendFormat(" AND KaiPiaoRen LIKE '%{0}%' ", searchInfo.KPRen); } if (searchInfo.KPSTime.HasValue) { cmdQuery.AppendFormat(" AND RiQi>'{0}' ", searchInfo.KPSTime.Value.AddDays(-1)); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { var item = new EyouSoft.Model.FinanceStructure.MFaPiaoInfo(); item.BeiZhu = rdr["BeiZhu"].ToString(); item.CaoZuoRenId = rdr.GetInt32(rdr.GetOrdinal("CaoZuoRenId")); item.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")); item.CrmId = rdr.GetInt32(rdr.GetOrdinal("CrmId")); item.Id = rdr.GetString(rdr.GetOrdinal("Id")); item.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); item.KaiPiaoRen = rdr["KaiPiaoRen"].ToString(); item.KaiPiaoRenId = rdr.GetInt32(rdr.GetOrdinal("KaiPiaoRenId")); item.PiaoHao = rdr["PiaoHao"].ToString(); item.RiQi = rdr.GetDateTime(rdr.GetOrdinal("RiQi")); items.Add(item); } } return(items); }
/// <summary> /// 修改开票信息,操作成功返回1,负值失败。 /// </summary> /// <param name="info">开票信息业务实体</param> /// <returns></returns> public int Update(EyouSoft.Model.FinanceStructure.MFaPiaoInfo info) { DbCommand cmd = _db.GetSqlStringCommand(SQL_UPDATE_Update); _db.AddInParameter(cmd, "RiQi", DbType.DateTime, info.RiQi); _db.AddInParameter(cmd, "JinE", DbType.Decimal, info.JinE); _db.AddInParameter(cmd, "PiaoHao", DbType.String, info.PiaoHao); _db.AddInParameter(cmd, "KaiPiaoRenId", DbType.Int32, info.KaiPiaoRenId); _db.AddInParameter(cmd, "KaiPiaoRen", DbType.String, info.KaiPiaoRen); _db.AddInParameter(cmd, "BeiZhu", DbType.String, info.BeiZhu); _db.AddInParameter(cmd, "Id", DbType.AnsiStringFixedLength, info.Id); return(DbHelper.ExecuteSql(cmd, _db) == 1 ? 1 : -1); }
/// <summary> /// lbtnSubmit_Click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtnSubmit_Click(object sender, EventArgs e) { var info = new EyouSoft.Model.FinanceStructure.MFaPiaoInfo(); info.BeiZhu = Utils.GetFormValue(txtBeiZhu.UniqueID); info.JinE = Utils.GetDecimal(Utils.GetFormValue(txtKaiPiaoJinE.UniqueID)); info.KaiPiaoRen = Utils.GetFormValue(txtKaiPiaoRen.UniqueID); info.KaiPiaoRenId = 0; info.PiaoHao = Utils.GetFormValue(txtPiaoHao.UniqueID); info.RiQi = Utils.GetDateTime(Utils.GetFormValue(txtKaiPiaoRiQi.UniqueID), DateTime.Now); if (!string.IsNullOrEmpty(EditId)) { info.Id = EditId; } else { info.CaoZuoRenId = SiteUserInfo.ID; info.CompanyId = CurrentUserCompanyID; info.CrmId = Utils.GetInt(Utils.GetQueryStringValue("kehudanweiid")); } int bllRetCode = 0; EyouSoft.BLL.FinanceStructure.BFaPiao bll = new EyouSoft.BLL.FinanceStructure.BFaPiao(); if (!string.IsNullOrEmpty(EditId)) { bllRetCode = bll.Update(info); } else { bllRetCode = bll.Insert(info); } if (bllRetCode == 1) { RegisterScript("alert('操作成功');reloadParentWindow();"); } else { RegisterAlertAndReloadScript("操作失败"); } }
/// <summary> /// 登记开票信息,操作成功返回开票登记编号,失败返回0。 /// </summary> /// <param name="info">开票信息业务实体</param> /// <returns></returns> public int Insert(EyouSoft.Model.FinanceStructure.MFaPiaoInfo info) { DbCommand cmd = _db.GetSqlStringCommand(SQL_INSERT_Insert); _db.AddInParameter(cmd, "Id", DbType.AnsiStringFixedLength, info.Id); _db.AddInParameter(cmd, "CompanyId", DbType.Int32, info.CompanyId); _db.AddInParameter(cmd, "CrmId", DbType.Int32, info.CrmId); _db.AddInParameter(cmd, "RiQi", DbType.DateTime, info.RiQi); _db.AddInParameter(cmd, "JinE", DbType.Decimal, info.JinE); _db.AddInParameter(cmd, "PiaoHao", DbType.String, info.PiaoHao); _db.AddInParameter(cmd, "KaiPiaoRenId", DbType.Int32, info.KaiPiaoRenId); _db.AddInParameter(cmd, "KaiPiaoRen", DbType.String, info.KaiPiaoRen); _db.AddInParameter(cmd, "BeiZhu", DbType.String, info.BeiZhu); _db.AddInParameter(cmd, "CaoZuoRenId", DbType.Int32, info.CaoZuoRenId); _db.AddInParameter(cmd, "IssueTime", DbType.DateTime, DateTime.Now); _db.AddInParameter(cmd, "IsDelete", DbType.AnsiStringFixedLength, "0"); return(DbHelper.ExecuteSql(cmd, _db) == 1 ? 1 : -1); }