/// <summary>
/// 获取金蝶默认科目配置信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <returns></returns>
public EyouSoft.Model.ComStructure.MKisConfigInfo GetKisConfigInfo(string companyId)
{
var info = new EyouSoft.Model.ComStructure.MKisConfigInfo();
DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetSettings);
_db.AddInParameter(cmd, "CompanyId", DbType.AnsiStringFixedLength, companyId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
int?_key = EyouSoft.Toolkit.Utils.GetIntNullable(rdr["Key"].ToString(), null);
if (!_key.HasValue)
{
continue;
}
string _value = rdr["Value"].ToString();
switch (_key)
{
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.订单收款_贷: info.Kis1000 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.订单收款_借: info.Kis1999 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.计调预付款_贷: info.Kis2000 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.计调预付款_借: info.Kis2999 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.导游备用金_贷: info.Kis3000 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.导游备用金_借: info.Kis3999 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_预付账款_借: info.Kis4000 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_预收账款_贷: info.Kis4500 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_团队借款_贷: info.Kis4501 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_现金_贷: info.Kis4999 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_主营业务收入_贷: info.Kis5000 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队借款_贷: info.Kis5001 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队预支_贷: info.Kis5002 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队支出_贷: info.Kis5003 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_应付账款_贷: info.Kis5004 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_现金_贷: info.Kis5005 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_主营业务成本_借: info.Kis5006 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_预收账款_借: info.Kis5007 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_现金_借: info.Kis5008 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_银行存款_借: info.Kis5009 = _value; break;
case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_应收帐款_借: info.Kis5999 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_主营业务收入_贷: info.Kis6000 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_团队预支_贷: info.Kis6001 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_应付账款_贷: info.Kis6002 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_团队支出_贷: info.Kis6003 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_预收账款_借: info.Kis6500 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_应收账款_借: info.Kis6501 = _value; break;
//case (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_主营业务成本_借: info.Kis6999 = _value; break;
default: break;
}
}
}
return(info);
}
/// <summary>
/// 设置金蝶默认科目配置信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="info">金蝶默认科目配置信息业务实体</param>
/// <returns></returns>
public bool SetKisConfigInfo(string companyId, EyouSoft.Model.ComStructure.MKisConfigInfo info)
{
return(dal.SetKisConfigInfo(companyId, info));
}
/// <summary>
/// 设置金蝶默认科目配置信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="info">金蝶默认科目配置信息业务实体</param>
/// <returns></returns>
public bool SetKisConfigInfo(string companyId, EyouSoft.Model.ComStructure.MKisConfigInfo info)
{
#region create xml
//xml格式<item><val id="key">value</val></item>
StringBuilder xml = new StringBuilder();
xml.Append("<item>");
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.订单收款_贷, info.Kis1000);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.订单收款_借, info.Kis1999);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.计调预付款_贷, info.Kis2000);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.计调预付款_借, info.Kis2999);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.导游备用金_贷, info.Kis3000);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.导游备用金_借, info.Kis3999);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_预付账款_借, info.Kis4000);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_预收账款_贷, info.Kis4500);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_团队借款_贷, info.Kis4501);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.团未完导游先报账_现金_贷, info.Kis4999);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_主营业务收入_贷, info.Kis5000);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队借款_贷, info.Kis5001);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队预支_贷, info.Kis5002);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_团队支出_贷, info.Kis5003);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_应付账款_贷, info.Kis5004);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_现金_贷, info.Kis5005);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_主营业务成本_借, info.Kis5006);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_预收账款_借, info.Kis5007);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_现金_借, info.Kis5008);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_银行存款_借, info.Kis5009);
xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.单团核算_应收帐款_借, info.Kis5999);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_主营业务收入_贷, info.Kis6000);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_团队预支_贷, info.Kis6001);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_应付账款_贷, info.Kis6002);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_团队支出_贷, info.Kis6003);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_预收账款_借, info.Kis6500);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_应收账款_借, info.Kis6501);
//xml.AppendFormat("<val id='{0}'>{1}</val>", (int)EyouSoft.Model.EnumType.KingDee.SysConfigDefaultSubject.后期收款_主营业务成本_借, info.Kis6999);
xml.Append("</item>");
#endregion
DbCommand cmd = this._db.GetStoredProcCommand(SQL_PROC_SetSettings);
_db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, companyId);
_db.AddInParameter(cmd, "@xml", DbType.Xml, xml.ToString());
_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(false);
}
else
{
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")) == 1);
}
}
