public static KindergartenInfo GetKindergartenInfo() { var Info = new KindergartenInfo(); var Kindergarten = new DataTable(); string Sql = string.Empty; try { Sql = string.Format(InitObject.GetScriptServiceInstance().GetKindergartenListById, BznsBase.KindergartenId); Kindergarten = MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, Sql, null).Tables[0]; if (Kindergarten.Rows.Count > 0) { DataRow dr = Kindergarten.Rows[0]; Info.Id = dr["kindergarten_id"].ToString(); Info.Code = dr["kindergarten_number"].ToString(); Info.Name = dr["kindergarten_nm"].ToString(); } } catch (Exception) { throw; } finally { Kindergarten = null; } return(Info); }
public static BrandInfo GetBrandInfo() { var Info = new BrandInfo(); var Brand = new DataTable(); string Sql = string.Empty; try { Sql = string.Format(InitObject.GetScriptServiceInstance().GetBrandListById, BznsBase.BrandID); Brand = MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, Sql, null).Tables[0]; if (Brand.Rows.Count > 0) { DataRow dr = Brand.Rows[0]; Info.Id = dr["Brand_ID"].ToString(); Info.Code = dr["Brand_Code"].ToString(); Info.Name = dr["Brand_Name"].ToString(); } } catch (Exception) { throw; } finally { Brand = null; } return(Info); }
public static void Insert(SysLogInfo Info) { var sql = string.Empty; try { sql = string.Format(InitObject.GetScriptServiceInstance().SysLogInsert, @Info.message, (int)Info.type, Info.moduleName, BznsBase.KindergartenId); int QueryValue = MySqlHelper.ExecuteNonQuery(BznsBase.GetConnectionString, BznsBase.GetCommandType, sql, null); } catch (Exception ex) { throw new Exception(ex.Message); } finally { } }
public static bool Export(SysLogType type) { var sql = string.Empty; var FilePath = string.Empty; var dt = new DataTable(); var result = false; try { switch ((int)type) { case 0: FilePath = ConfigurationManager.AppSettings["InfoLogPath"]; break; case 1: FilePath = ConfigurationManager.AppSettings["WarningLogPath"]; break; default: FilePath = ConfigurationManager.AppSettings["ErrorLogPath"]; break; } sql = string.Format(InitObject.GetScriptServiceInstance().SysLogList, (int)type, BznsBase.KindergartenId); dt = DBHelper.MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, sql, null).Tables[0]; ExcelHelper.ExcelHelper.DataTableToExcel(dt, string.Empty, FilePath); result = true; } catch (Exception ex) { SysLog.Insert(new SysLogInfo(ex.Message, SysLogType.ERROR, "System Log")); } finally { } return(result); }