private bool UpdateTBDetailAndTBAux()
{
try
{
var p = new DynamicParameters();
p.Add("@pzEndDate", _endDate);
SqlMapperUtil.InsertUpdateOrDeleteStoredProc("UpdateTBDetailTBAuxJE", p, conStr);
}
catch (Exception err)
{
return(false);
}
return(true);
}
private bool InitTbDetail()
{
try
{
#region old
/*
* DataTable dtDetail = new DataTable();
* dtDetail.TableName = "TBDetail";
#region columns
* dtDetail.Columns.Add("ID");
* dtDetail.Columns.Add("ProjectID");
* dtDetail.Columns.Add("FSCode");
* dtDetail.Columns.Add("AccountCode");
* dtDetail.Columns.Add("AuxiliaryCode");
* dtDetail.Columns.Add("AccAuxName");
* dtDetail.Columns.Add("DataType", typeof(int));
* dtDetail.Columns.Add("TBGrouping");
* dtDetail.Columns.Add("TBType", typeof(int));
* dtDetail.Columns.Add("IsAccMx", typeof(int));
* dtDetail.Columns.Add("IsMx", typeof(int));
* dtDetail.Columns.Add("IsAux", typeof(int));
* dtDetail.Columns.Add("kmsx");
* dtDetail.Columns.Add("Yefx", typeof(int));
* dtDetail.Columns.Add("SourceFSCode");
* dtDetail.Columns.Add("Sqqmye", typeof(decimal));
* dtDetail.Columns.Add("Qqccgz", typeof(decimal));
* dtDetail.Columns.Add("jfje", typeof(decimal));
* dtDetail.Columns.Add("dfje", typeof(decimal));
* dtDetail.Columns.Add("CrjeJF", typeof(decimal));
* dtDetail.Columns.Add("CrjeDF", typeof(decimal));
* dtDetail.Columns.Add("AjeJF", typeof(decimal));
* dtDetail.Columns.Add("AjeDF", typeof(decimal));
* dtDetail.Columns.Add("RjeJF", typeof(decimal));
* dtDetail.Columns.Add("RjeDF", typeof(decimal));
* dtDetail.Columns.Add("TaxBase", typeof(decimal));
* dtDetail.Columns.Add("PY1", typeof(decimal));
* dtDetail.Columns.Add("jfje1", typeof(decimal));
* dtDetail.Columns.Add("dfje1", typeof(decimal));
* dtDetail.Columns.Add("jfje2", typeof(decimal));
* dtDetail.Columns.Add("dfje2", typeof(decimal));
#endregion
* string qsql = "select distinct NEWID() ID ,a.AccountCode,space(0) AS SourceFSCode," +
* " a.AccountName as AccAuxName,a.jb as TBType,0 AS IsMx, a.UpperCode TBGrouping, a.Ncye AS Sqqmye,space(0) fscode,1 yefx,0 kmsx," +
* "0 AS isAux,a.ismx AS isAccMx,0 AS DataType,Qqccgz,Hsxms,TypeCode from dbo.Account a with(nolock) ";
*
* dynamic ds = SqlMapperUtil.SqlWithParams<dynamic>(qsql, null, conStr);
* foreach (var vd in ds)
* {
* DataRow dr = dtDetail.NewRow();
* dr["ID"] = vd.ID;
* dr["ProjectID"]=dbName;
* dr["FSCode"] = vd.fscode;
* dr["AccountCode"] = vd.AccountCode;
* dr["AuxiliaryCode"] = vd.TypeCode;
* dr["AccAuxName"] = vd.AccAuxName;
* dr["DataType"] = vd.DataType;
* dr["TBGrouping"] = vd.TBGrouping;
* dr["TBType"] = vd.TBType;
* dr["IsAccMx"] = vd.isAccMx;
* dr["IsMx"] = vd.IsMx;
* dr["IsAux"] = 0;
* dr["kmsx"] = vd.kmsx;
* dr["Yefx"] = vd.yefx;
* dr["SourceFSCode"] = vd.SourceFSCode;
* dr["Sqqmye"] = vd.Sqqmye==null?0M:vd.Sqqmye;
* dr["Qqccgz"] = vd.Qqccgz;
* dr["jfje"] = 0M;
* dr["dfje"] = 0M;
* dr["CrjeJF"] = 0M;
* dr["CrjeDF"] = 0M;
* dr["AjeJF"] = 0M;
* dr["AjeDF"] = 0M;
* dr["RjeJF"] = 0M;
* dr["RjeDF"] = 0M;
* dr["TaxBase"] = 0M;
* dr["PY1"] = 0M;
* dr["jfje1"] = 0M;
* dr["dfje1"] = 0M;
* dr["jfje2"] = 0M;
* dr["dfje2"] = 0M;
* dtDetail.Rows.Add(dr);
*
* }
* string execSQL = " truncate table " + dtDetail.TableName;
* SqlMapperUtil.CMDExcute(execSQL, null, conStr);
* SqlServerHelper.SqlBulkCopy(dtDetail, conStr); */
#endregion
var p = new DynamicParameters();
p.Add("@ProjectID", _projectID);
SqlMapperUtil.InsertUpdateOrDeleteStoredProc("InitTbAccTable", p, conStr);
}
catch (Exception err)
{
return(false);
}
return(true);
}