/// <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);
}
