/// <summary>
/// 为主表插入数据
/// </summary>
/// <param name="sellOrderModel"></param>
/// <param name="tran"></param>
private static void InsertSellOrder(FeesModel sellOrderModel, TransactionManager tran,out int IntID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.Fees(");
strSql.Append("CompanyCD,FeesNo ,FeesNum,FeesType,InvoiceType,CreateDate,ContactUnits,ContactType,AcceWay,SubjectsNo,TotalPrice,Executor,DeptID,ConfirmStatus,Confirmor,IsAccount ,Accountor ,SourceNo,AccountsStatus,CurrencyType,CurrencyRate,Note,ProjectID)");
strSql.Append(" values (");
strSql.Append("@CompanyCD,@FeesNo ,@FeesNum,@FeesType,@InvoiceType,@CreateDate,@ContactUnits,@ContactType,@AcceWay,@SubjectsNo,@TotalPrice,@Executor,@DeptID,@ConfirmStatus,@Confirmor,@IsAccount ,@Accountor ,@SourceNo,@AccountsStatus,@CurrencyType,@CurrencyRate,@Note,@ProjectID) ");
strSql.Append(" set @IntID= @@IDENTITY");
//SqlParameter[] param = null;
//ArrayList lcmd = new ArrayList();
#region 参数
//lcmd.Add(SqlHelper.GetParameterFromString("@CompanyCD", sellOrderModel.CompanyCD));
//lcmd.Add(SqlHelper.GetParameterFromString("@FeesNo ", sellOrderModel.FeesNo));
//lcmd.Add(SqlHelper.GetParameterFromString("@FeesNum", sellOrderModel.FeesNum));
//lcmd.Add(SqlHelper.GetParameterFromString("@FeesType", sellOrderModel.FeesType));
//lcmd.Add(SqlHelper.GetParameterFromString("@InvoiceType", sellOrderModel.InvoiceType));
//lcmd.Add(SqlHelper.GetParameterFromString("@CreateDate", sellOrderModel.CreateDate.ToString()));
//lcmd.Add(SqlHelper.GetParameterFromString("@ContactUnits", sellOrderModel.ContactUnits));
//lcmd.Add(SqlHelper.GetParameterFromString("@ContactType", sellOrderModel.ContactType));
//lcmd.Add(SqlHelper.GetParameterFromString("@AcceWay", sellOrderModel.AcceWay));
//lcmd.Add(SqlHelper.GetParameterFromString("@SubjectsNo", sellOrderModel.SubjectsNo));
//lcmd.Add(SqlHelper.GetParameterFromString("@TotalPrice", sellOrderModel.TotalPrice.ToString()));
//lcmd.Add(SqlHelper.GetParameterFromString("@Executor", sellOrderModel.Executor));
//lcmd.Add(SqlHelper.GetParameterFromString("@DeptID", sellOrderModel.DeptID));
//lcmd.Add(SqlHelper.GetParameterFromString("@ConfirmStatus", sellOrderModel.ConfirmStatus));
//lcmd.Add(SqlHelper.GetParameterFromString("@Confirmor", sellOrderModel.Confirmor));
//lcmd.Add(SqlHelper.GetParameterFromString("@ConfirmDate", sellOrderModel.ConfirmDate.ToString()));
//lcmd.Add(SqlHelper.GetParameterFromString("@IsAccount", sellOrderModel.IsAccount));
//lcmd.Add(SqlHelper.GetParameterFromString("@Accountor", sellOrderModel.Accountor));
//lcmd.Add(SqlHelper.GetParameterFromString("@AccountDate", sellOrderModel.AccountDate.ToString()));
//lcmd.Add(SqlHelper.GetParameterFromString("@SourceNo", sellOrderModel.SourceNo));
//lcmd.Add(SqlHelper.GetParameterFromString("@AccountsStatus", sellOrderModel.AccountsStatus));
//lcmd.Add(SqlHelper.GetParameterFromString("@CurrencyType", sellOrderModel.CurrencyType));
//lcmd.Add(SqlHelper.GetParameterFromString("@CurrencyRate", sellOrderModel.CurrencyRate.ToString()));
//lcmd.Add(SqlHelper.GetParameterFromString("@Note", sellOrderModel.Note));
//lcmd.Add(SqlHelper.GetParameterFromString("@IntID", sellOrderModel.ID));
#endregion
SqlParameter[] parms = new SqlParameter[24];
parms[0] = SqlHelper.GetParameter("@CompanyCD", sellOrderModel.CompanyCD);
parms[1] = SqlHelper.GetParameter("@FeesNo", sellOrderModel.FeesNo);
parms[2] = SqlHelper.GetParameter("@FeesNum", sellOrderModel.FeesNum);
parms[3] = SqlHelper.GetParameter("@FeesType", sellOrderModel.FeesType);
parms[4] = SqlHelper.GetParameter("@InvoiceType", sellOrderModel.InvoiceType);
parms[5] = SqlHelper.GetParameter("@CreateDate", sellOrderModel.CreateDate);
parms[6] = SqlHelper.GetParameter("@ContactUnits", sellOrderModel.ContactUnits);
parms[7] = SqlHelper.GetParameter("@ContactType", sellOrderModel.ContactType);
parms[8] = SqlHelper.GetParameter("@AcceWay", sellOrderModel.AcceWay);
parms[9] = SqlHelper.GetParameter("@SubjectsNo", sellOrderModel.SubjectsNo);
parms[10] = SqlHelper.GetParameter("@TotalPrice", sellOrderModel.TotalPrice);
parms[11] = SqlHelper.GetParameter("@Executor", sellOrderModel.Executor);
parms[12] = SqlHelper.GetParameter("@DeptID", sellOrderModel.DeptID);
parms[13] = SqlHelper.GetParameter("@ConfirmStatus", sellOrderModel.ConfirmStatus);
parms[14] = SqlHelper.GetParameter("@Confirmor", sellOrderModel.Confirmor);
parms[15] = SqlHelper.GetParameter("@IsAccount", sellOrderModel.IsAccount);
parms[16] = SqlHelper.GetParameter("@Accountor", sellOrderModel.Accountor);
parms[17] = SqlHelper.GetParameter("@SourceNo", sellOrderModel.SourceNo);
parms[18] = SqlHelper.GetParameter("@AccountsStatus", sellOrderModel.AccountsStatus);
parms[19] = SqlHelper.GetParameter("@CurrencyType", sellOrderModel.CurrencyType);
parms[20] = SqlHelper.GetParameter("@CurrencyRate", sellOrderModel.CurrencyRate);
parms[21] = SqlHelper.GetParameter("@Note", sellOrderModel.Note);
parms[22] = SqlHelper.GetParameter("@ProjectID", sellOrderModel.ProjectID);
parms[23] = SqlHelper.GetOutputParameter("@IntID", SqlDbType.Int);
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parms);
IntID = Convert.ToInt32(parms[23].Value);
}
public static DataTable ExportFeesBySearch(string CompanyCD, FeesModel FeesM, string DateBegin, string DateEnd, string PriceB, string PriceE)
{
try
{
#region 查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine("SELECT a.ID ");
searchSql.AppendLine(" ,a.CompanyCD ");
searchSql.AppendLine(" ,a.FeesNo ");
searchSql.AppendLine(",(case a.InvoiceType when '1' then '增值税发票' when '2' then '普通地税' when '3' then '普通国税' else '收据' end)InvoiceType ");
searchSql.AppendLine(",(case a.FeesType ");
searchSql.AppendLine(" when '0' then (case a.ContactType ");
searchSql.AppendLine(" when '1' then (select CustName from officedba.ProviderInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '2' then (select CustName from officedba.CustInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '3' then (select EmployeeName from officedba.EmployeeInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" end) ");
searchSql.AppendLine(" when '1' then (select CustName from officedba.ProviderInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '2' then (select CustName from officedba.ProviderInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '3' then (select CustName from officedba.ProviderInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '4' then (select CustName from officedba.CustInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '5' then (select CustName from officedba.CustInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '6' then (select CustName from officedba.CustInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '7' then (select EmployeeName from officedba.EmployeeInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '8' then (select CustName from officedba.CustInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" when '9' then (select CustName from officedba.ProviderInfo where id=a.ContactUnits) ");
searchSql.AppendLine(" end) CustName ");
searchSql.AppendLine(" ,a.ContactUnits ");
searchSql.AppendLine(" , CONVERT(varchar(100), a.CreateDate, 23) CreateDate ");
searchSql.AppendLine(" ,a.TotalPrice,a.Confirmor,b.EmployeeName ConfirmorName ");
searchSql.AppendLine(" , CONVERT(varchar(100), a.ConfirmDate, 23) ConfirmDate ");
searchSql.AppendLine(" ,(case a.IsAccount when '1' then '已登记' else '未登记' end)IsAccount ");
searchSql.AppendLine(" FROM officedba.Fees a ");
searchSql.AppendLine(" left join officedba.EmployeeInfo b on b.id = a.Confirmor ");
searchSql.AppendLine(" WHERE a.CompanyCD = @CompanyCD ");
#endregion
#region 定义查询的命令
SqlCommand comm = new SqlCommand();
//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", CompanyCD));
//所属项目
if (!string.IsNullOrEmpty(FeesM.ProjectID))
{
searchSql.AppendLine(" AND a.ProjectID = @ProjectID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProjectID", FeesM.ProjectID));
}
//编号
if (!string.IsNullOrEmpty(FeesM.FeesNo))
{
searchSql.AppendLine(" AND a.FeesNo LIKE '%' + @FeesNo + '%' ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@FeesNo", FeesM.FeesNo));
}
//票据类型
if (FeesM.InvoiceType != "")
{
searchSql.AppendLine(" AND a.InvoiceType = @InvoiceType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@InvoiceType", FeesM.InvoiceType));
}
//开始时间
if (DateBegin != "")
{
searchSql.AppendLine(" AND a.CreateDate >= @DateBegin ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DateBegin", DateBegin));
}
//结束时间
if (DateEnd != "")
{
searchSql.AppendLine(" AND a.CreateDate <= @DateEnd ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DateEnd", DateEnd));
}
//金额B
if (PriceB != "")
{
searchSql.AppendLine(" AND a.TotalPrice >= @PriceB ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PriceB", PriceB));
}
//金额E
if (PriceE != "")
{
searchSql.AppendLine(" AND a.TotalPrice <= @PriceE ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PriceE", PriceE));
}
//源单类型
if (FeesM.FeesType != "")
{
searchSql.AppendLine(" AND a.FeesType = @FeesType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@FeesType", FeesM.FeesType));
}
//确认状态
if (FeesM.ConfirmStatus != "")
{
searchSql.AppendLine(" AND a.ConfirmStatus = @ConfirmStatus ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ConfirmStatus", FeesM.ConfirmStatus));
}
//是否登记
if (FeesM.IsAccount != "")
{
searchSql.AppendLine(" AND a.IsAccount = @IsAccount ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@IsAccount ", FeesM.IsAccount));
}
#endregion
//设定comm的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
catch
{
return null;
}
}
/// <summary>
/// 添加新单据
/// </summary>
/// <returns></returns>
public static bool Insert(FeesModel sellOrderModel, List<FeesDetailModel> sellOrderDetailModellList, out string strMsg,out int Id)
{
bool isSucc = false;//是否添加成功
strMsg = "";
Id = 0;
//判断单据编号是否存在
if (NoIsExist(sellOrderModel.FeesNo))
{
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
InsertSellOrder(sellOrderModel, tran,out Id);
InsertSellOrderDetail(sellOrderDetailModellList, tran);
if (sellOrderModel.FeesType != "0")
{
//非无源单时，更改源单开票状态
updateSourceByFeesType(sellOrderModel.FeesType, sellOrderModel.SourceNo, tran);
}
tran.Commit();
isSucc = true;
strMsg = "保存成功！";
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
throw ex;
}
}
else
{
isSucc = false;
strMsg = "该编号已被使用，请输入未使用的编号！";
}
return isSucc;
}
/// <summary>
/// 跟新主表数据
/// </summary>
/// <param name="sellOrderModel"></param>
/// <param name="tran"></param>
private static void UpdateSellOrder(FeesModel sellOrderModel, TransactionManager tran)
{
StringBuilder strSql = new StringBuilder();
#region sql语句
strSql.Append("update officedba.Fees set ");
strSql.Append("FeesNum=@FeesNum,");
strSql.Append("FeesType=@FeesType,");
strSql.Append("InvoiceType=@InvoiceType,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("ContactUnits=@ContactUnits,");
strSql.Append("ContactType=@ContactType,");
strSql.Append("AcceWay=@AcceWay,");
strSql.Append("SubjectsNo=@SubjectsNo,");
strSql.Append("TotalPrice=@TotalPrice,");
strSql.Append("Executor=@Executor,");
strSql.Append("DeptID=@DeptID,");
strSql.Append("ConfirmStatus=@ConfirmStatus,");
strSql.Append("Confirmor=@Confirmor,");
strSql.Append("ConfirmDate=@ConfirmDate,");
strSql.Append("IsAccount=@IsAccount ,");
strSql.Append("Accountor =@Accountor ,");
strSql.Append("AccountDate =@AccountDate ,");
strSql.Append("SourceNo=@SourceNo,");
strSql.Append("AccountsStatus=@AccountsStatus,");
strSql.Append("CurrencyType=@CurrencyType,");
strSql.Append("CurrencyRate=@CurrencyRate,");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("Note=@Note");
strSql.Append(" where CompanyCD=@CompanyCD and FeesNo =@FeesNo ");
#endregion
SqlParameter[] param = null;
ArrayList lcmd = new ArrayList();
#region 参数
lcmd.Add(SqlHelper.GetParameterFromString("@CompanyCD", sellOrderModel.CompanyCD));
lcmd.Add(SqlHelper.GetParameterFromString("@FeesNo ", sellOrderModel.FeesNo));
lcmd.Add(SqlHelper.GetParameterFromString("@FeesNum", sellOrderModel.FeesNum));
lcmd.Add(SqlHelper.GetParameterFromString("@FeesType", sellOrderModel.FeesType));
lcmd.Add(SqlHelper.GetParameterFromString("@InvoiceType", sellOrderModel.InvoiceType));
lcmd.Add(SqlHelper.GetParameterFromString("@CreateDate", sellOrderModel.CreateDate.ToString()));
lcmd.Add(SqlHelper.GetParameterFromString("@ContactUnits", sellOrderModel.ContactUnits));
lcmd.Add(SqlHelper.GetParameterFromString("@ContactType", sellOrderModel.ContactType));
lcmd.Add(SqlHelper.GetParameterFromString("@AcceWay", sellOrderModel.AcceWay));
lcmd.Add(SqlHelper.GetParameterFromString("@SubjectsNo", sellOrderModel.SubjectsNo));
lcmd.Add(SqlHelper.GetParameterFromString("@TotalPrice", sellOrderModel.TotalPrice.ToString()));
lcmd.Add(SqlHelper.GetParameterFromString("@Executor", sellOrderModel.Executor));
lcmd.Add(SqlHelper.GetParameterFromString("@DeptID", sellOrderModel.DeptID));
lcmd.Add(SqlHelper.GetParameterFromString("@ConfirmStatus", sellOrderModel.ConfirmStatus));
lcmd.Add(SqlHelper.GetParameterFromString("@Confirmor", sellOrderModel.Confirmor));
lcmd.Add(SqlHelper.GetParameterFromString("@ConfirmDate", sellOrderModel.ConfirmDate.ToString()));
lcmd.Add(SqlHelper.GetParameterFromString("@IsAccount", sellOrderModel.IsAccount));
lcmd.Add(SqlHelper.GetParameterFromString("@Accountor", sellOrderModel.Accountor));
lcmd.Add(SqlHelper.GetParameterFromString("@AccountDate", sellOrderModel.AccountDate.ToString()));
lcmd.Add(SqlHelper.GetParameterFromString("@SourceNo", sellOrderModel.SourceNo));
lcmd.Add(SqlHelper.GetParameterFromString("@AccountsStatus", sellOrderModel.AccountsStatus));
lcmd.Add(SqlHelper.GetParameterFromString("@CurrencyType", sellOrderModel.CurrencyType));
lcmd.Add(SqlHelper.GetParameterFromString("@CurrencyRate", sellOrderModel.CurrencyRate.ToString()));
lcmd.Add(SqlHelper.GetParameterFromString("@Note", sellOrderModel.Note));
lcmd.Add(SqlHelper.GetParameterFromString("@ProjectID", sellOrderModel.ProjectID));
#endregion
if (lcmd != null && lcmd.Count > 0)
{
param = new SqlParameter[lcmd.Count];
for (int i = 0; i < lcmd.Count; i++)
{
param[i] = (SqlParameter)lcmd[i];
}
}
foreach (SqlParameter para in param)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), param);
}
public static bool ConfirmFees(string OrderNO,FeesModel FeesM, List<FeesDetailModel> FeesDetailM, out string strMsg)
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string strSq = string.Empty;
bool isSuc = false;
strMsg = "";
//判断单据是否为制单状态，非制单状态不能确认
if (isHandle(OrderNO, "0"))
{
//TransactionManager tran = new TransactionManager();
//tran.BeginTransaction();
try
{
//判断是否启用自动生成凭证
//((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsApply;//自动审核登帐
//((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsVoucher;//自动生成凭证
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsVoucher == true)
{
AttestBillModel Model = new AttestBillModel();//凭证主表实例
ArrayList DetailList = new ArrayList();//凭证明细数组
Model.CompanyCD = CompanyCD;
Model.FromName = "";
Model.Attachment = 1;//附件数
Model.AttestName = "记账凭证";//凭证名称
Model.VoucherDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));//凭证日期
Model.AttestNo = "记-" + VoucherDBHelper.GetMaxAttestNo(CompanyCD, DateTime.Now.ToString("yyyy-MM-dd"));//凭证号
Model.Creator = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;//制单人
Model.CreateDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));//制单日期
Model.FromTbale = "officedba.Fees";//来源表名
Model.FromValue = FeesM.ID;//来源表主键
AttestBillDetailsModel DetailModel = new AttestBillDetailsModel();//凭证明细表实例
DetailModel.Abstract = FeesM.Note;// dt.Rows[0]["Abstract"].ToString();//摘要
DetailModel.CurrencyTypeID = Convert.ToInt32(FeesM.CurrencyType); //币种
DetailModel.ExchangeRate = FeesM.CurrencyRate;//汇率
DetailModel.SubjectsCD = FeesM.SubjectsNo;//科目编号
DetailModel.OriginalAmount = FeesM.TotalPrice;//原币金额
DetailModel.DebitAmount = 0;//借方金额
DetailModel.CreditAmount = FeesM.TotalPrice * Convert.ToDecimal(FeesM.CurrencyRate);//贷方金额
DetailModel.SubjectsDetails = "";
DetailModel.FormTBName = "";
DetailModel.FileName = "";
string Auciliary = VoucherDBHelper.GetSubjectsAuciliaryCD(FeesM.SubjectsNo, CompanyCD);
if (Auciliary == "供应商" || Auciliary == "客户" || Auciliary == "职员")
{
DetailModel.SubjectsDetails = FeesM.ContactUnits;//辅助核算
if (Auciliary == "供应商")
{
DetailModel.FormTBName = "officedba.ProviderInfo";
DetailModel.FileName = "CustName";
}
else if (Auciliary == "客户")
{
DetailModel.FormTBName = "officedba.CustInfo";
DetailModel.FileName = "CustName";
}
else
{
DetailModel.FormTBName = "officedba.EmployeeInfo";
DetailModel.FileName = "EmployeeName";
}
}
DetailList.Add(DetailModel);
//foreach (DataRow row in tempdt.Rows)//根据凭证模板构建凭证明细数组
foreach (FeesDetailModel FDetailM in FeesDetailM)
{
AttestBillDetailsModel DetailM = new AttestBillDetailsModel();//凭证明细表实例
DetailM.Abstract = FeesM.Note;//摘要
DetailM.CurrencyTypeID = Convert.ToInt32(FeesM.CurrencyType);//币种
DetailM.ExchangeRate = FeesM.CurrencyRate;//汇率
DetailM.SubjectsCD = FDetailM.SubjectsNo;//科目编号
DetailM.OriginalAmount = FDetailM.FeeTotal;//原币金额
DetailM.DebitAmount = FDetailM.FeeTotal * Convert.ToDecimal(FeesM.CurrencyRate);//借方金额
DetailM.CreditAmount = 0;//贷方金额
DetailM.SubjectsDetails = "";
DetailM.FormTBName = "";
DetailM.FileName = "";
DetailList.Add(DetailM);
}
//自动生成凭证并根据IsApply判断是否登帐 --生成成功
int BillID = 0;
string IsA = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsApply == true ? "1" : "0";
if (VoucherDBHelper.InsertIntoAttestBill(Model, DetailList, out BillID, IsA))
{
SqlParameter[] paras = new SqlParameter[3];
strSq = "update officedba.Fees set ConfirmStatus='1' , Confirmor=@EmployeeID, ";
strSq += " ConfirmDate=getdate(),IsAccount='1',Accountor=@EmployeeID,AccountDate=getdate() ";
paras[0] = new SqlParameter("@EmployeeID", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
paras[1] = new SqlParameter("@CompanyCD", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD);
paras[2] = new SqlParameter("@FeesNo", OrderNO);
strSq += " WHERE FeesNo = @FeesNo and CompanyCD=@CompanyCD";
//SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSq, paras);
SqlHelper.ExecuteTransSql(strSq.ToString(), paras);
if (SqlHelper.Result.OprateCount > 0)
{
isSuc = true;
strMsg = "确认成功！";
}
else
{
isSuc = false;
strMsg = "生成凭证失败！";
}
}
}
else
{
SqlParameter[] paras = new SqlParameter[3];
strSq = "update officedba.Fees set ConfirmStatus='1' , Confirmor=@EmployeeID, ";
strSq += " ConfirmDate=getdate() ";
paras[0] = new SqlParameter("@EmployeeID", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
paras[1] = new SqlParameter("@CompanyCD", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD);
paras[2] = new SqlParameter("@FeesNo", OrderNO);
strSq += " WHERE FeesNo = @FeesNo and CompanyCD=@CompanyCD";
SqlHelper.ExecuteTransSql(strSq.ToString(), paras);
if (SqlHelper.Result.OprateCount > 0)
{
isSuc = true;
strMsg = "确认成功！";
}
else
{
isSuc = false;
strMsg = "确认失败！";
}
}
}
catch (Exception ex)
{
//tran.Rollback();
isSuc = false;
strMsg = "确认失败，请联系系统管理员！";
throw ex;
}
}
else
{
isSuc = false;
strMsg = "该单据已被其他用户确认，不可再次确认！";
}
return isSuc;
}
public static bool Update(FeesModel sellOrderModel, List<FeesDetailModel> sellOrderDetailModellList,out string strMsg)
{
bool isSucc = false;//是否添加成功
strMsg = "";
if (IsUpdate(sellOrderModel.FeesNo))
{
string strSql = "delete from officedba.FeesDetail where FeesNo =@FeesNo and CompanyCD=@CompanyCD";
SqlParameter[] paras = { new SqlParameter("@FeesNo ", sellOrderModel.FeesNo ), new SqlParameter("@CompanyCD", sellOrderModel.CompanyCD) };
// string strSql1 = "delete from officedba.SellOrderFeeDetail where OrderNo=@OrderNo and CompanyCD=@CompanyCD";
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
UpdateSellOrder(sellOrderModel, tran);
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras);
InsertSellOrderDetail(sellOrderDetailModellList, tran);
tran.Commit();
isSucc = true;
strMsg = "保存成功！";
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
throw ex;
}
}
else
{
isSucc = false;
strMsg = "非制单状态的未提交审批、审批未通过或撤销审批单据不可修改！";
}
return isSucc;
}
/// <summary>
/// 添加新单据
/// </summary>
/// <returns></returns>
public static bool Insert(FeesModel sellOrderModel, List<FeesDetailModel> sellOrderDetailModellList, out string strMsg,out int Id)
{
bool isSuc = false;
string remark = string.Empty;
strMsg = "";
Id = 0;
try
{
isSuc = FeesDBHelper.Insert(sellOrderModel, sellOrderDetailModellList, out strMsg,out Id);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch
{
////输出日志
//SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, ConstUtil.MODULE_ID_SELLORDER_ADD);
////设置操作成功标识
//remark = ConstUtil.LOG_PROCESS_FAILED;
}
//SellLogCommon.InsertLog(sellOrderModel.OrderNo, ConstUtil.MODULE_ID_SELLORDER_ADD, ConstUtil.CODING_RULE_TABLE_SELLORDER, remark, ConstUtil.LOG_PROCESS_INSERT);
return isSuc;
}
public static DataTable ExportFeesBySearch(string CompanyCD, FeesModel FeesM, string DateBegin, string DateEnd, string PriceB, string PriceE)
{
return FeesDBHelper.ExportFeesBySearch(CompanyCD, FeesM, DateBegin, DateEnd, PriceB, PriceE);
}
public static bool ConfirmFees(string OrderNO, FeesModel FeesM, List<FeesDetailModel> FeesDetailM, out string strMsg)
{
return FeesDBHelper.ConfirmFees(OrderNO,FeesM,FeesDetailM, out strMsg);
}
public static DataTable GetFeesBySearch(string CompanyCD, FeesModel FeesM, string DateBegin, string DateEnd, string PriceB, string PriceE, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return FeesDBHelper.GetFeesBySearch(CompanyCD, FeesM, DateBegin, DateEnd, PriceB, PriceE, pageIndex, pageCount, ord, ref TotalCount);
}