本文整理汇总了C#中NFMT.Common.ResultModel类的典型用法代码示例。如果您正苦于以下问题:C# ResultModel类的具体用法?C# ResultModel怎么用?C# ResultModel使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ResultModel类属于NFMT.Common命名空间,在下文中一共展示了ResultModel类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CheckContractSubBusinessInvoiceApplyConfirm
public ResultModel CheckContractSubBusinessInvoiceApplyConfirm(UserModel user, int subId)
{
ResultModel result = new ResultModel();
string cmdText = "select COUNT(*) from dbo.Inv_BusinessInvoice bi inner join dbo.Invoice inv on inv.InvoiceId = bi.InvoiceId where bi.SubContractId = 1 and inv.InvoiceStatus in (@entryStatus,@readyStatus)";
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@subId", subId);
paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);
object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
int i = 0;
if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
{
result.ResultStatus = -1;
result.Message = "检验业务发票失败";
return result;
}
if (i > 0)
{
result.ResultStatus = -1;
result.Message = "子合约中含有未完成的业务发票,不能进行确认完成操作。";
return result;
}
result.ResultStatus = 0;
result.Message = "业务发票全部完成";
return result;
}
示例2: GetContractOutCorp
public ResultModel GetContractOutCorp(UserModel user, int subId)
{
ResultModel result = new ResultModel();
try
{
int readyStatus = (int)StatusEnum.已生效;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select corpdetail.CorpId,corpdetail.CorpName ");
sb.Append("from dbo.Con_ContractSub sub ");
sb.AppendFormat("inner join dbo.Con_ContractCorporationDetail corpdetail on sub.ContractId = corpdetail.ContractId and corpdetail.DetailStatus>={0} ", readyStatus);
sb.AppendFormat("and corpdetail.IsInnerCorp = 0 where sub.SubId = {0} order by corpdetail.IsDefaultCorp desc", subId);
DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, sb.ToString(), null, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
result.Message = "获取成功";
result.ResultStatus = 0;
result.ReturnValue = dt;
}
else
{
result.Message = "获取失败";
result.ResultStatus = -1;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例3: GetPriceConfirmStockListSelect
public ResultModel GetPriceConfirmStockListSelect(UserModel user, int subId,System.Text.StringBuilder sb)
{
ResultModel result = new ResultModel();
try
{
System.Data.DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, sb.ToString(), null, System.Data.CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
result.ResultStatus = 0;
result.Message = "获取成功";
result.ReturnValue = dt;
}
else
{
result.ResultStatus = -1;
result.Message = "获取失败";
}
}
catch (Exception e)
{
result.ResultStatus = -1;
result.Message = e.Message;
}
return result;
}
示例4: ChangePwd
public ResultModel ChangePwd(UserModel user, string newPwd)
{
ResultModel result = new ResultModel();
try
{
string sql = string.Format("update dbo.Account set PassWord = '{0}' where EmpId = {1} and AccStatus = {2}", newPwd.Trim(), user.EmpId, (int)Common.StatusEnum.已生效);
int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
if (i > 0)
{
result.ResultStatus = 0;
result.Message = "修改密码成功";
}
else
{
result.ResultStatus = -1;
result.Message = "修改密码失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例5: GetCurrencyId
public ResultModel GetCurrencyId(UserModel user, int stockId)
{
ResultModel result = new ResultModel();
try
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select sub.SettleCurrency from St_StockLog sl ");
sb.Append("left join dbo.Con_ContractSub sub on sl.SubContractId = sub.SubId ");
sb.AppendFormat("where sl.StockId = {0}", stockId);
object obj = NFMT.DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, sb.ToString(), null);
int i;
if (obj != null && !string.IsNullOrEmpty(obj.ToString()) && int.TryParse(obj.ToString(), out i))
{
result.Message = "获取成功";
result.ResultStatus = 0;
result.ReturnValue = i;
}
else
{
result.Message = "获取失败";
result.ResultStatus = -1;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例6: CheckContractSubCashInConfirm
public ResultModel CheckContractSubCashInConfirm(UserModel user, int subId)
{
ResultModel result = new ResultModel();
string cmdText = "select COUNT(*) from NFMT.dbo.Fun_CashInContract_Ref cic inner join NFMT.dbo.Fun_CashIn ci on cic.CashInId = ci.CashInId where cic.SubContractId [email protected] and ci.CashInStatus in (@entryStatus,@readyStatus)";
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@subId", subId);
paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);
object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
int i = 0;
if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
{
result.ResultStatus = -1;
result.Message = "检验收款登记失败";
return result;
}
if (i > 0)
{
result.ResultStatus = -1;
result.Message = "子合约中含有未完成的收款登记,不能进行确认完成操作。";
return result;
}
result.ResultStatus = 0;
result.Message = "收款登记全部完成";
return result;
}
示例7: BaseAudit
public ResultModel BaseAudit(UserModel user, Model.DataSource obj, bool isPass)
{
ResultModel result = new ResultModel();
try
{
NFMT.Common.Operate operate = NFMT.Common.Operate.CreateOperate(obj.DalName, obj.AssName);
if (operate == null)
{
result.Message = "模板不存在";
result.ResultStatus = -1;
return result;
}
result = operate.Get(user, obj.BaseName, obj.TableCode, obj.RowId);
if (result.ResultStatus == 0)
{
NFMT.Common.IModel model = result.ReturnValue as NFMT.Common.IModel;
result = operate.Audit(user, model, isPass);
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
示例8: GetPriceByContractId
public ResultModel GetPriceByContractId(UserModel user, int contractId)
{
ResultModel result = new ResultModel();
if (contractId < 1)
{
result.Message = "序号不能小于1";
return result;
}
List<SqlParameter> paras = new List<SqlParameter>();
SqlParameter para = new SqlParameter("@contractId", SqlDbType.Int, 4);
para.Value = contractId;
paras.Add(para);
try
{
string cmdText = "select * from NFMT.dbo.Con_ContractPrice where ContractId [email protected]";
result = Get(user, CommandType.Text, cmdText, paras.ToArray());
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
示例9: Confirm
public ResultModel Confirm(UserModel user, int cashInId)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取收款登记
result = this.cashinDAL.Get(user, cashInId);
if (result.ResultStatus != 0)
return result;
Model.CashIn cashIn = result.ReturnValue as Model.CashIn;
if (cashIn == null || cashIn.CashInId <= 0)
{
result.ResultStatus = -1;
result.Message = "收款登记不存在";
return result;
}
result = this.cashinDAL.Confirm(user, cashIn);
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
示例10: GetContractDetail
public ResultModel GetContractDetail(UserModel user, int contractId, TradeDirectionEnum tradeDirection)
{
ResultModel result = new ResultModel();
try
{
System.Data.DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, GetSQLString(contractId, tradeDirection), null, System.Data.CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
result.ResultStatus = 0;
result.Message = "获取成功";
result.ReturnValue = dt;
}
else
{
result.ResultStatus = -1;
result.Message = "获取失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例11: GetCanAllotBala
public ResultModel GetCanAllotBala(UserModel user, int cashInId, bool isUpdate, decimal alreadyAllotBala = 0)
{
ResultModel result = new ResultModel();
try
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(" select ci.CashInBala - ISNULL(ref.bala,0) ");
if (isUpdate)
sb.AppendFormat(" + {0} ", alreadyAllotBala);
sb.AppendFormat(" from dbo.Fun_CashIn ci left join (select ref.CashInId,SUM(ISNULL(ref.AllotBala,0)) bala from dbo.Fun_CashInCorp_Ref ref where ref.DetailStatus >={0} group by ref.CashInId) ref on ci.CashInId = ref.CashInId where ci.CashInId = {1}", (int)Common.StatusEnum.已生效,cashInId);
object obj = NFMT.DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, sb.ToString(), null);
decimal canAllotBala = 0;
if (obj == null || string.IsNullOrEmpty(obj.ToString()) || !decimal.TryParse(obj.ToString(), out canAllotBala))
{
result.ResultStatus = -1;
result.Message = "获取失败";
}
else
{
result.ReturnValue = canAllotBala;
result.Message = "获取成功";
result.ResultStatus = 0;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例12: CheckContractSubPayApplyConfirm
/// <summary>
/// 校验子合约中付款申请是否全部确认完成
/// </summary>
/// <param name="user"></param>
/// <param name="subId"></param>
/// <returns></returns>
public ResultModel CheckContractSubPayApplyConfirm(UserModel user, int subId)
{
ResultModel result = new ResultModel();
string cmdText = "select COUNT(*) from NFMT.dbo.Fun_ContractPayApply_Ref pac inner join NFMT.dbo.Fun_PayApply pa on pa.PayApplyId = pac.PayApplyId inner join NFMT.dbo.Apply app on pa.ApplyId = app.ApplyId where pac.ContractSubId [email protected] and app.ApplyStatus in (@entryStatus,@readyStatus)";
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@subId", subId);
paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);
object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
int i = 0;
if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
{
result.ResultStatus = -1;
result.Message = "检验付款申请失败";
return result;
}
if (i > 0)
{
result.ResultStatus = -1;
result.Message = "子合约中含有未完成的付款申请,不能进行确认完成操作。";
return result;
}
result.ResultStatus = 0;
result.Message = "付款申请全部完成";
return result;
}
示例13: InvalidAll
public ResultModel InvalidAll(UserModel user, int allotId)
{
ResultModel result = new ResultModel();
try
{
string sql = string.Format("update dbo.Fun_CashInStcok_Ref set DetailStatus = {0} where AllotId = {1}", (int)Common.StatusEnum.已作废, allotId);
int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
if (i > 0)
{
result.ResultStatus = 0;
result.Message = "作废成功";
}
else
{
result.Message = "作废失败";
result.ResultStatus = -1;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
示例14: InsertOperateLog
/// <summary>
/// 添加操作记录
/// </summary>
/// <param name="user">当前操作用户</param>
/// <param name="log">记录实体</param>
/// <param name="details">记录明细列表</param>
/// <returns></returns>
public static ResultModel InsertOperateLog(UserModel user, OperateLogModel log, List<OperateLogDetailModel> details)
{
ResultModel result = new ResultModel();
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
result = InsertOperateLog(user, log);
if (result.ResultStatus != 0)
return result;
foreach (OperateLogDetailModel m in details)
{
result = InsertOperateLogDetail(user, m);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
result.AffectCount = 1;
result.Message = string.Format("操作记录添加成功,明细共{0}条", details.Count);
result.ResultStatus = 0;
result.ReturnValue = 1;
}
return result;
}
示例15: ChangePwd
public ResultModel ChangePwd(UserModel user, string oldPwd, string newPwd)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = accountDAL.ValidatePwd(user, oldPwd);
if (result.ResultStatus != 0)
return result;
result = accountDAL.ChangePwd(user, newPwd);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
finally
{
if (result.ResultStatus != 0)
this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
else if (this.Log.IsInfoEnabled)
this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue);
}
return result;
}