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); }