public static void GenerateFullBackup()
{
if (AppInit.AppInfo.BackupPath.Length == 0)
{
return;
}
DbFun.CloseConn();
string ltimepunch = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + ".ikbkp";
System.IO.Compression.ZipFile.CreateFromDirectory(Application.StartupPath, AppInit.AppInfo.BackupPath + @"\" + ltimepunch);
DbFun.OpenConn();
}
private void MDIMain_Load(object sender, EventArgs e)
{
//MessageBox.Show("Test1");
//MessageBox.Show(LicenseChecker.GetActivationCode());
FrmCompanySelection objcmp = new FrmCompanySelection();
objcmp.ShowDialog();
//MessageBox.Show("Test2");
if (System.Diagnostics.Debugger.IsAttached)
{
AppInit.UserInfo.UserId = 1;
AppInit.UserInfo.isSuperAdmin = true;
}
if (AppInit.UserInfo.UserId == 0)
{
FrmLogin objlogin = new FrmLogin();
objlogin.ShowDialog();
}
FrmLogin.GetCompanyInfo();
this.Text = AppInit.CompanyInfo.CompanyName;
DbFun.OpenConn();
// super admin permission
if (AppInit.UserInfo.isSuperAdmin)
{
reportDesignToolStripMenuItem.Visible = true;
dashDesignerToolStripMenuItem.Visible = true;
}
AppInit.SoftwareSettings.IntiSetting();
if (System.IO.Directory.Exists(Application.StartupPath + @"\Temp"))
{
System.IO.DirectoryInfo directory = new System.IO.DirectoryInfo(Application.StartupPath + @"\Temp");
foreach (System.IO.FileInfo file in directory.GetFiles())
{
file.Delete();
}
}
////------------ Dashboard
//DevExpress.DashboardCommon.Dashboard dbs = new DevExpress.DashboardCommon.Dashboard();
//dbs.ConfigureDataConnection += dbs_ConfigureDataConnection;
//dbs.LoadFromXml(Application.StartupPath + @"\Dash\D1.xml");
//db_view_Dash.Dashboard = dbs;
//InitDashbaord();
}
string ReturnQueryString(int _reportid)
{
string qry = "";
qry = "Select * from MISReport Where ReportId =" + _reportid;
DataTable ltbl = DbFun.ExecDtblRtrn(qry);
foreach (DataRow dr in ltbl.Rows)
{
mQry = dr["Qry"].ToString();
mReportTitle = dr["ReportTitle"].ToString();
return(mQry);
}
return("");
}
private void FrmReportGrid_Shown(object sender, EventArgs e)
{
if (mReportId == 0)
{
return;
}
DataTable ldts = DbFun.ExecDtblRtrn(ReturnQueryString(mReportId));
xList.DataSource = ldts;
xListDetail.BestFitColumns();
foreach (DataColumn dcols in ldts.Columns)
{
string dttype = dcols.DataType.ToString();
if (dttype == "System.Int32" | dttype == "System.Decimal" | dttype == "System.Double" | dttype == "System.Int16" | dttype == "System.Int64")
{
xListDetail.Columns[dcols.ColumnName].Summary.Add(DevExpress.Data.SummaryItemType.Sum, dcols.ColumnName);
//xListDetail.Columns[ (dcols.ColumnName).Summary.Add(DevExpress.Data.SummaryItemType.Sum, dcols.ColumnName);
GridGroupSummaryItem item1 = new GridGroupSummaryItem();
item1.FieldName = dcols.ColumnName;
item1.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//item1.DisplayFormat = "Total {0:c2}"
item1.ShowInGroupColumnFooter = xListDetail.Columns[dcols.ColumnName];
xListDetail.GroupSummary.Add(item1);
}
}
this.Text = "Report > " + mReportTitle;
if (System.IO.File.Exists(Application.StartupPath + @"\Layout\" + mReportTitle))
{
xList.ForceInitialize();
xList.MainView.RestoreLayoutFromXml(Application.StartupPath + @"\Layout\" + mReportTitle);
}
//PreviewPrintableComponent(xList,xList.LookAndFeel);
}
private string MakeSql(GlobalUser gu, string queryCconf, string orderStr, string whereJsonStr, IList <QueryPara> paraList, ref string whereStr, string dbType)
{
IList <QueryRowBtnShowCondition> whereList = new List <QueryRowBtnShowCondition>();
if (!string.IsNullOrEmpty(whereJsonStr))
{
whereList = JSON.EncodeToEntity <IList <QueryRowBtnShowCondition> >(whereJsonStr);
}
foreach (var tmp in whereList.Where(x => x.OpType == null))
{
queryCconf = queryCconf.Replace("@(" + tmp.ObjFiled + ")", tmp.Value);
}
if (paraList != null)
{
foreach (var tmp in paraList)
{
if (tmp.Value == "@(NOWDATA)")
{
tmp.Value = DateTime.Today.ToString("yyyy-MM-dd");
}
queryCconf = queryCconf.Replace("@(" + tmp.ParaName + ")", tmp.Value);
}
}
StringBuilder whereSb = new StringBuilder();
foreach (var tmp in whereList.Where(x => x.OpType != null))
{
var nowType = tmp.FieldType.ToLower();
int subIndex = tmp.FieldType.IndexOf(".");
if (subIndex > -1)
{
nowType = nowType.Substring(subIndex + 1);
}
switch (nowType)
{
case "string":
switch (tmp.OpType)
{
case "in":
whereSb.Append(string.Format(" {0} {1} ('{2}') and ", tmp.ObjFiled, tmp.OpType, tmp.Value.Replace(",", "','")));
break;
default:
if (tmp.OpType == "like")
{
tmp.Value = "%" + tmp.Value + "%";
}
whereSb.Append(string.Format(" {0} {1} '{2}' and ", tmp.ObjFiled, tmp.OpType, tmp.Value));
break;
}
break;
case "datetime":
whereSb.Append(string.Format(" {0} and ", DbFun.WhereData(dbType, tmp.ObjFiled, tmp.OpType, tmp.Value)));
break;
default:
if (tmp.OpType == "in")
{
whereSb.Append(string.Format(" {0} {1} ('{2}') and ", tmp.ObjFiled, tmp.OpType, tmp.Value.Replace(",", "','")));
}
else
{
whereSb.Append(string.Format(" {0} {1} {2} and ", tmp.ObjFiled, tmp.OpType, tmp.Value));
}
break;
}
}
if (whereSb.Length > 4)
{
whereSb = whereSb.Remove(whereSb.Length - 4, 4);
}
whereStr = whereSb.ToString();
queryCconf = ReplacePer(queryCconf, gu, paraList);
return(queryCconf);
}
