/// <summary>
/// 获取礼品卡信息
/// </summary>
/// <param name="liPinKaId">礼品卡编号</param>
/// <returns></returns>
public EyouSoft.Model.YlStructure.MLiPinKaInfo GetLiPinKaInfo(string liPinKaId)
{
EyouSoft.Model.YlStructure.MLiPinKaInfo info = null;
DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetLiPinKaInfo);
_db.AddInParameter(cmd, "@LiPinKaId", DbType.AnsiStringFixedLength, liPinKaId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.YlStructure.MLiPinKaInfo();
info.CompanyId = rdr["CompanyId"].ToString();
info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE"));
info.FengMian = rdr["FengMian"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
info.JinE1 = rdr.GetDecimal(rdr.GetOrdinal("JinE1"));
info.LeiXing = (EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing)rdr.GetByte(rdr.GetOrdinal("LeiXing"));
info.LiPinKaId = rdr["LiPinKaId"].ToString();
info.LiPinKaKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("LiPinKaKuaiDiJinE"));
info.MiaoShu = rdr["MiaoShu"].ToString();
info.MingCheng = rdr["MingCheng"].ToString();
info.OperatorId = rdr["OperatorId"].ToString();
info.XuZhi = rdr["XuZhi"].ToString();
}
}
return(info);
}
/// <summary>
/// baocun
/// </summary>
void BaoCun()
{
var info = new EyouSoft.Model.YlStructure.MLiPinKaInfo();
info.CompanyId = CurrentUserCompanyID;
info.FaPiaoKuaiDiJinE = Utils.GetDecimal(Utils.GetFormValue(txtFaPiaoKuaiDiJinE.UniqueID));
info.FengMian = string.Empty;
info.IssueTime = DateTime.Now;
info.JinE = Utils.GetDecimal(Utils.GetFormValue(txtJinE.UniqueID));
info.JinE1 = Utils.GetDecimal(Utils.GetFormValue(txtJinE1.UniqueID));
info.LeiXing = Utils.GetEnumValue <EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing>(Utils.GetFormValue("txtLeiXing"), EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing.电子卡);
info.LiPinKaId = LiPinKaId;
info.LiPinKaKuaiDiJinE = 0;
info.MiaoShu = Utils.EditInputText(Request.Form[txtMiaoShu.UniqueID]);
info.MingCheng = Utils.GetFormValue(txtMingCheng.UniqueID);
info.OperatorId = SiteUserInfo.UserId;
info.XuZhi = Utils.EditInputText(Request.Form[txtXuZhi.UniqueID]);
var items = upload1.Files;
var items1 = upload1.YuanFiles;
if (items != null && items.Count > 0)
{
info.FengMian = items[0].FilePath;
}
else if (items1 != null && items1.Count > 0)
{
info.FengMian = items1[0].FilePath;
}
int bllRetCode = 0;
if (string.IsNullOrEmpty(LiPinKaId))
{
bllRetCode = new EyouSoft.BLL.YlStructure.BLiPinKa().InsertLiPinKa(info);
}
else
{
bllRetCode = new EyouSoft.BLL.YlStructure.BLiPinKa().UpdateLiPinKa(info);
}
if (bllRetCode == 1)
{
RCWE(UtilsCommons.AjaxReturnJson("1", "操作成功"));
}
else
{
RCWE(UtilsCommons.AjaxReturnJson("0", "操作失败"));
}
}
/// <summary>
/// 获取礼品卡集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.YlStructure.MLiPinKaInfo> GetLiPinKas(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MLiPinKaChaXunInfo chaXun)
{
IList <EyouSoft.Model.YlStructure.MLiPinKaInfo> items = new List <EyouSoft.Model.YlStructure.MLiPinKaInfo>();
string tableName = "tbl_YL_WZ_LiPinKa";
string fields = "*";
string orderByString = "IssueTime DESC";
string sumString = string.Empty;
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" CompanyId='{0}' ", companyId);
if (chaXun != null)
{
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.MingCheng))
{
sql.AppendFormat(" AND MingCheng LIKE '%{0}%' ", chaXun.MingCheng);
}
}
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.YlStructure.MLiPinKaInfo();
info.CompanyId = rdr["CompanyId"].ToString();
info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE"));
info.FengMian = rdr["FengMian"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
info.JinE1 = rdr.GetDecimal(rdr.GetOrdinal("JinE1"));
info.LeiXing = (EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing)rdr.GetByte(rdr.GetOrdinal("LeiXing"));
info.LiPinKaId = rdr["LiPinKaId"].ToString();
info.LiPinKaKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("LiPinKaKuaiDiJinE"));
info.MiaoShu = rdr["MiaoShu"].ToString();
info.MingCheng = rdr["MingCheng"].ToString();
info.OperatorId = rdr["OperatorId"].ToString();
items.Add(info);
}
}
return(items);
}
/// <summary>
/// 礼品卡修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int UpdateLiPinKa(EyouSoft.Model.YlStructure.MLiPinKaInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.CompanyId) ||
string.IsNullOrEmpty(info.OperatorId) ||
string.IsNullOrEmpty(info.LiPinKaId))
{
return(0);
}
info.IssueTime = DateTime.Now;
int dalRetCode = dal.LiPinKa_CU(info);
return(dalRetCode);
}
/// <summary>
/// 礼品卡新增、修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int LiPinKa_CU(EyouSoft.Model.YlStructure.MLiPinKaInfo info)
{
DbCommand cmd = _db.GetStoredProcCommand("proc_YL_LiPinKa_CU");
_db.AddInParameter(cmd, "@LiPinKaId", DbType.AnsiStringFixedLength, info.LiPinKaId);
_db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, info.CompanyId);
_db.AddInParameter(cmd, "@MingCheng", DbType.String, info.MingCheng);
_db.AddInParameter(cmd, "@JinE", DbType.Decimal, info.JinE);
_db.AddInParameter(cmd, "@JinE1", DbType.Decimal, info.JinE1);
_db.AddInParameter(cmd, "@FengMian", DbType.String, info.FengMian);
_db.AddInParameter(cmd, "@MiaoShu", DbType.String, info.MiaoShu);
_db.AddInParameter(cmd, "@LeiXing", DbType.Byte, info.LeiXing);
_db.AddInParameter(cmd, "@FaPiaoKuaiDiJinE", DbType.Decimal, info.FaPiaoKuaiDiJinE);
_db.AddInParameter(cmd, "@LiPinKaKuaiDiJinE", DbType.Decimal, info.LiPinKaKuaiDiJinE);
_db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, info.OperatorId);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@XuZhi", DbType.String, info.XuZhi);
_db.AddOutParameter(cmd, "RetCode", DbType.Int32, 4);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
else
{
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
}