public String Create(WorkshopModel workshopModel)
{
using (var connection = new MySqlConnection(Constant.getDatabaseConnectionString()))
{
/*
* FactoryModel factory = connection
* .Query<FactoryModel>("SELECT * FROM factory WHERE factoryName=@fn", new
* {
* fn = workshopModel.Factory
* }).FirstOrDefault();
*/
FactoryModel factory = connection
.Query <FactoryModel>("SELECT * FROM factory WHERE factoryName=@fn AND factory.city IN (SELECT city.id FROM city WHERE city.cityName=@cn)", new
{
fn = workshopModel.Factory,
cn = workshopModel.City
}).FirstOrDefault();
int rows = connection
.Execute(
"INSERT INTO workshop(workshopName, workshopPhoneNumber, workshopAddress, remark, factory) VALUES (@wn, @wpn, @wa, @r, @f)", new
{
wn = workshopModel.WorkshopName,
wpn = workshopModel.WorkshopPhoneNumber,
wa = workshopModel.WorkshopAddress,
r = workshopModel.Remark,
f = factory.Id
});
return(rows == 1 ? "success" : "error");
}
}
public FactorySerializer GetFactoryById(int id)
{
FactoryModel factory = this._factoryDao.GetById(id);
FactorySerializer result = new FactorySerializer(factory);
return(result);
}
public static void LoadAttribute(List <Assembly> BusinessDll, ModulePlugin mp)
{
List <WinformControllerAttributeInfo> cmdControllerList = new List <WinformControllerAttributeInfo>();
for (int k = 0; k < BusinessDll.Count; k++)
{
//System.Reflection.Assembly assembly = System.Reflection.Assembly.LoadFrom(BusinessDll[k]);
System.Reflection.Assembly assembly = BusinessDll[k];
Type[] types = assembly.GetTypes();
for (int i = 0; i < types.Length; i++)
{
WinformControllerAttribute[] winC = ((WinformControllerAttribute[])types[i].GetCustomAttributes(typeof(WinformControllerAttribute), true));
if (winC.Length > 0)
{
WinformControllerAttributeInfo cmdC = new WinformControllerAttributeInfo();
cmdC.controllerName = types[i].Name;
cmdC.defaultViewName = winC[0].DefaultViewName;
//cmdC.winformController = (AbstractController)Activator.CreateInstance(types[i], null);
cmdC.winformController = (AbstractController)FactoryModel.GetObject(types[i], mp.database, mp.container, mp.cache, mp.plugin.name, null);
cmdC.MethodList = new List <WinformMethodAttributeInfo>();
cmdC.ViewList = new List <WinformViewAttributeInfo>();
MethodInfo[] property = types[i].GetMethods();
for (int n = 0; n < property.Length; n++)
{
WinformMethodAttribute[] WinM = (WinformMethodAttribute[])property[n].GetCustomAttributes(typeof(WinformMethodAttribute), true);
if (WinM.Length > 0)
{
WinformMethodAttributeInfo cmdM = new WinformMethodAttributeInfo();
cmdM.methodName = property[n].Name;
cmdM.methodInfo = property[n];
if (WinM[0].OpenDBKeys != null && WinM[0].OpenDBKeys.ToString().Trim() != "")
{
cmdM.dbkeys = WinM[0].OpenDBKeys.Split(new char[] { ',' }).ToList();
}
cmdC.MethodList.Add(cmdM);
}
}
WinformViewAttribute[] viewAttribute = (WinformViewAttribute[])types[i].GetCustomAttributes(typeof(WinformViewAttribute), true);
for (int n = 0; n < viewAttribute.Length; n++)
{
WinformViewAttributeInfo winView = new WinformViewAttributeInfo();
winView.Name = viewAttribute[n].Name;
winView.DllName = viewAttribute[n].DllName;
winView.ViewTypeName = viewAttribute[n].ViewTypeName;
winView.IsDefaultView = winView.Name == cmdC.defaultViewName ? true : false;
//Assembly _assembly = Assembly.LoadFrom(winView.DllName);
winView.ViewType = assembly.GetType(winView.ViewTypeName, false, true);
cmdC.ViewList.Add(winView);
}
cmdControllerList.Add(cmdC);
}
}
}
mp.cache.Add(mp.plugin.name + "@" + GetCacheKey(), cmdControllerList);
}
/// <summary>
/// 初始化头部数据
/// </summary>
/// <param name="_dtPoints"></param>
private void InitTop(DataTable _dtPoints)
{
int a = _dtPoints.Columns.Count;
objRl = bllRl.GetConfigRL();
drPoits = _dtPoints.Select("T_UNITID='0'");
object _objDayDl = bllDl.GetDLAll(strDl, DateTime.Now.ToString("yyyy-MM-dd 0:00:00"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
object _objMonthDl = bllDl.GetDLAll(strDl, DateTime.Now.ToString("yyyy-MM-1 0:00:00"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
object _objYearDl = bllDl.GetDLAll(strDl, DateTime.Now.ToString("yyyy-1-1 0:00:00"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
string[] _strPoints = new string[1];
if (drPoits.Length > 0)
{
_strPoints[0] = drPoits[0][2].ToString();
}
FactoryModel factory = new FactoryModel();
double _val = factory.Power;
//val = bllPoint.GetPointVal(_strPoints);
object _obj = new
{
rl = objRl,
power = _val,
day = _objDayDl,
month = _objMonthDl,
year = _objYearDl
};
string result = JsonConvert.SerializeObject(_obj);
Response.Write(result);
Response.End();
}
public IHttpActionResult GetMessageByFactoryId(int factoryId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
{
try
{
FactoryModel factoryModel = new FactoryModel();
int companyId = factoryModel.GetByIdForInternal(factoryId).CompanyId;
CompanyModel companyModel = new CompanyModel();
CompanyModel.Format_Detail company = companyModel.GetById(companyId);
var companySubscription = companyModel.GetValidSubscriptionPlanByCompanyId(companyId);
if (companySubscription == null)
{
throw new Exception("can't find valid subscription plan.");
}
DocumentDBHelper docDBHelpler = new DocumentDBHelper(companyId, companySubscription.CosmosDBConnectionString);
return(Ok(docDBHelpler.GetMessageByFactoryId(factoryId, top, hours, order)));
}
catch (Exception ex)
{
StringBuilder logMessage = LogHelper.BuildExceptionMessage(ex);
string logAPI = "[Get] " + Request.RequestUri.ToString();
Global._appLogger.Error(logAPI + logMessage);
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public void addSeats()
{
Boolean odd = false;
for (int i = 0; i < coach.totalNumberSeats; i++)
{
if (false == odd)
{
if (i < 12)
{
coach.seats.Add(FactoryModel.seatFactory(seatType.firstClassWindow, i, 20.00, false));
}
else
{
coach.seats.Add(FactoryModel.seatFactory(seatType.secondClassWindow, i, 10.00, false));
}
odd = true;
}
else
{
if (i < 12)
{
coach.seats.Add(FactoryModel.seatFactory(seatType.firstClassAlis, i, 20.00, false));
}
else
{
coach.seats.Add(FactoryModel.seatFactory(seatType.secondClassAlis, i, 10.00, false));
}
odd = false;
}
}
}
public IHttpActionResult CreateFactoryFormData([FromBody] FactoryModel.Format_Create factory)
{
int companyId = Global.GetCompanyIdFromToken();
string logForm = "Form : " + JsonConvert.SerializeObject(factory);
string logAPI = "[Post] " + Request.RequestUri.ToString();
if (!ModelState.IsValid || factory == null)
{
Global._appLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
return(Content(HttpStatusCode.BadRequest, HttpResponseFormat.InvaildData()));
}
FactoryModel factoryModel = new FactoryModel();
try
{
int id = factoryModel.Create(companyId, factory);
return(Content(HttpStatusCode.OK, HttpResponseFormat.Success(id)));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
StringBuilder logMessage = LogHelper.BuildExceptionMessage(ex);
logMessage.AppendLine(logForm);
Global._appLogger.Error(logAPI + logMessage);
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public static List <T> ToList <T>(DataTable table, AbstractDatabase Db, IUnityContainer container, ICacheManager cache, string pluginName, string unityname)
{
Type type = typeof(T);
List <T> objects = new List <T>();
T obj = FactoryModel.GetObject <T>(Db, container, cache, pluginName, unityname);
if (table != null && table.Rows.Count > 0)
{
while (objects.Count < table.Rows.Count)
{
objects.Add((T)((ICloneable)obj).Clone());
}
foreach (PropertyInfo property in type.GetProperties())
{
if (table.Columns.IndexOf(property.Name) >= 0)
{
for (int index = 0; index < table.Rows.Count; index++)
{
object val = table.Rows[index][property.Name];
if (val == System.DBNull.Value)
{
val = null;
}
property.SetValue((object)objects[index], val, null);
}
}
}
}
return(objects);
}
public List <object> GetDeviceTree(String city, String factory)
{
using (var connection = new SqlConnection(Constant.getDatabaseConnectionString()))
{
CityModel c = connection.Query <CityModel>("select * from city where cityName=@cn", new { cn = city })
.FirstOrDefault();
FactoryModel fac = connection
.Query <FactoryModel>("select * from factory where factoryName=@fn and city=@cid", new { fn = factory, cid = c.Id })
.FirstOrDefault();
List <WorkshopModel> workshops =
connection.Query <WorkshopModel>("select * from workshop where factory=@fid", new{ fid = fac.Id })
.ToList();
List <object> result = new List <object>();
foreach (WorkshopModel w in workshops)
{
List <DeviceModel> devices = connection
.Query <DeviceModel>("select * from device where workshop=@wid", new { wid = w.Id })
.ToList();
List <object> deviceResult = new List <object>();
foreach (DeviceModel d in devices)
{
deviceResult.Add(new { label = d.DeviceName, id = d.Id });
}
result.Add(new { label = w.WorkshopName, children = deviceResult });
}
return(result);
}
}
public void addCoach(coachType type)
{
coach = FactoryModel.coachFactory(type, null, null, false);
coach.coachNumber = count;
addSeats();
coaches.Add(coach);
count++;
}
// GET: Factories/Edit/5
public ActionResult Edit(int id)
{
FactoryModel model = factoryService.GetById(id);
if (model == null)
{
return(HttpNotFound());
}
return(View(model));
}
public ActionResult Edit(FactoryModel model)
{
if (ModelState.IsValid)
{
factoryService.Update(model);
factoryService.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public String CreateNewFactory(FactorySerializer factorySerializer)
{
FactoryModel factoryModel = new FactoryModel();
factoryModel.FactoryName = factorySerializer.factoryName;
factoryModel.FactoryPhoneNumber = factorySerializer.factoryPhoneNumber;
factoryModel.FactoryAddress = factorySerializer.factoryAddress;
factoryModel.Remark = factorySerializer.remark;
factoryModel.City = factorySerializer.city;
return(this._factoryDao.Create(factoryModel));
}
public static bool SetGlobalRenderState_Prefix(FactoryModel __instance)
{
if (GameMain.mainPlayer == null && GameMain.data == null)
{
// GameMain.data is destroyed while loading into the game, but we had the planets factory loaded in galaxy select when selecting a custom birth planet.
// thus unload the data here to prevent nre spam.
__instance.planet.UnloadFactory();
return(false);
}
return(true);
}
public String Update(int id, DeviceModel deviceModel)
{
using (var connection = new SqlConnection(Constant.getDatabaseConnectionString()))
{
CityModel city = connection.Query <CityModel>(
"SELECT * FROM city WHERE city.cityName=@cn", new
{
cn = deviceModel.City
}).FirstOrDefault();
FactoryModel factory = connection.Query <FactoryModel>(
"SELECT * FROM factory WHERE factory.factoryName=@fn", new
{
fn = deviceModel.Factory
}).FirstOrDefault();
WorkshopModel workshop = connection.Query <WorkshopModel>(
"SELECT * FROM workshop WHERE workshop.workshopName=@wn", new
{
wn = deviceModel.Workshop
}).FirstOrDefault();
int rows = connection
.Execute(
"UPDATE device " +
"SET hardwareDeviceID=@hdid, " +
"deviceName=@dn, " +
"city=@c, " +
"factory=@f, " +
"workshop=@w, " +
"deviceState=@ds, " +
"imageUrl=@iu, " +
"gatewayId=@gid, " +
"mac=@m, " +
"deviceType=@dt, " +
"remark=@r, " +
"updateTime=CURRENT_TIMESTAMP " +
"WHERE device.id=@deviceId",
new
{
deviceId = deviceModel.Id,
hdid = deviceModel.HardwareDeviceId,
dn = deviceModel.DeviceName,
c = city.Id,
f = factory.Id,
w = workshop.Id,
ds = deviceModel.DeviceState,
iu = deviceModel.ImageUrl,
gid = deviceModel.GatewayId,
m = deviceModel.Mac,
dt = deviceModel.DeviceType,
r = deviceModel.Remark
});
return(rows == 1 ? "success" : "error");
}
}
public String UpdateFactory(int id, FactorySerializer factorySerializer)
{
FactoryModel factoryModel = new FactoryModel();
factoryModel.Id = factorySerializer.id;
factoryModel.FactoryName = factorySerializer.factoryName;
factoryModel.FactoryPhoneNumber = factorySerializer.factoryPhoneNumber;
factoryModel.FactoryAddress = factorySerializer.factoryAddress;
factoryModel.Remark = factorySerializer.remark;
factoryModel.City = factorySerializer.city;
return(this._factoryDao.Update(id, factoryModel));
}
public List <WorkshopModel> GetAffiliateWorkshop(String fName)
{
using (var connection = new SqlConnection(Constant.getDatabaseConnectionString()))
{
FactoryModel factory = connection
.Query <FactoryModel>("select * from factory where factoryName=@fn", new { fn = fName })
.FirstOrDefault();
int factoryId = factory.Id;
List <WorkshopModel> workshops = connection
.Query <WorkshopModel>("select * from workshop where factory=@fid", new { fid = factoryId }).ToList();
return(workshops);
}
}
public FactorySerializer(FactoryModel factoryModel)
{
this.id = factoryModel.Id;
this.factoryName = factoryModel.FactoryName;
this.factoryPhoneNumber = factoryModel.FactoryPhoneNumber;
this.factoryAddress = factoryModel.FactoryAddress;
this.remark = factoryModel.Remark;
this.createTime = factoryModel.CreateTime
.ToString(Constant.getDateFormatString());
this.updateTime = factoryModel.UpdateTime
.ToString(Constant.getDateFormatString());
this.city = factoryModel.City;
}
public void Factory()
{
SelectedBuilding = BuiltObject.CreatePrototype("Factory", 3, 2, 2, 50, 5);
BuildingPreview = new GameObject();
BuildingPreview.name = "BuildingPreviewObject";
BuildingPreview.AddComponent <MeshFilter>();
BuildingPreview.AddComponent <MeshRenderer>();
BuildingPreview.transform.localScale = FactoryModel.transform.localScale;
BuildingPreview.GetComponent <MeshFilter>().sharedMesh = FactoryModel.GetComponent <MeshFilter>().sharedMesh;
BuildingPreview.GetComponent <MeshRenderer>().sharedMaterials = FactoryModel.GetComponent <MeshRenderer>().sharedMaterials;
BuildingPreview.AddComponent <MeshCollider>();
BuildingPreview.AddComponent <Factory>();
}
public override List <string> DatabaseContextFactoryUsings(FactoryModel data)
{
var usings = new List <string>
{
"Microsoft.EntityFrameworkCore.Design"
};
if (Settings.IncludeCodeGeneratedAttribute)
{
usings.Add("System.CodeDom.Compiler");
}
return(usings);
}
static void oth5(FactoryModel __instance)
{
var _this = __instance;
var entityData = _this.gpuiManager.objectRenderers;
if (!_this.disableFactoryEntities)
{
SetShowModelData(entityData);
}
_this.disableCargos = showItemT[0];
_this.disableTraffics = showItemT[1];
_this.disableLogisticDrones = showItemT[2];
_this.disableFactoryEntities = showItemT[3];
}
public override List <string> DatabaseContextFactoryUsings(FactoryModel data)
{
var usings = new List <string>
{
"System",
"System.Data.Entity.Infrastructure"
};
if (Settings.IncludeCodeGeneratedAttribute)
{
usings.Add("System.CodeDom.Compiler");
}
return(usings);
}
public String Create(DeviceModel deviceModel)
{
using (var connection = new MySqlConnection(Constant.getDatabaseConnectionString()))
{
CityModel city = connection.Query <CityModel>(
"SELECT * FROM city WHERE city.cityName=@cn", new
{
cn = deviceModel.City
}).FirstOrDefault();
FactoryModel factory = connection.Query <FactoryModel>(
"SELECT * FROM factory WHERE factory.factoryName=@fn", new
{
fn = deviceModel.Factory
}).FirstOrDefault();
WorkshopModel workshop = connection.Query <WorkshopModel>(
"SELECT * FROM workshop WHERE workshop.workshopName=@wn", new
{
wn = deviceModel.Workshop
}).FirstOrDefault();
GatewayModel gateway = connection.Query <GatewayModel>("select * from gateway where gatewayName=@gn",
new { gn = deviceModel.GatewayId }).FirstOrDefault();
int deviceType = connection.Query <int>(
"select id from config where configTag=@ct and configValue=@cv", new
{
ct = "deviceType",
cv = deviceModel.DeviceType
}).FirstOrDefault();
int rows = connection.Execute(
"INSERT INTO " +
"device(hardwareDeviceID, deviceName, city, factory, workshop, deviceState, imageUrl, gatewayId, mac, deviceType, remark)" +
" VALUES (@hdid, @dn, @c, @f, @w, @ds, @iu, @gid, @m, @dt, @r)", new
{
hdid = deviceModel.HardwareDeviceId,
dn = deviceModel.DeviceName,
c = city.Id,
f = factory.Id,
w = workshop.Id,
ds = deviceModel.DeviceState,
iu = deviceModel.ImageUrl,
gid = gateway.Id,
m = deviceModel.Mac,
dt = deviceType,
r = deviceModel.Remark
});
return(rows == 1 ? "success" : "error");
}
}
public IHttpActionResult GetFactoryById(int factoryId)
{
try
{
FactoryModel model = new FactoryModel();
//RedisCacheHelper.SetKeyValue(cacheKey, JsonConvert.SerializeObject(company));
return(Content(HttpStatusCode.OK, model.External_GetById(factoryId, UserToken.CompanyId)));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public async Task PostSuccess(string factoryName, string factoryPhoneNumber, string factoryAddress, string remark, string city)
{
var data = new FactoryModel
{
FactoryName = factoryName,
FactoryPhoneNumber = factoryPhoneNumber,
FactoryAddress = factoryAddress,
Remark = remark,
City = city
};
var content = new StringContent(data.ToJson(), Encoding.UTF8, "text/json");
var response = await this._httpClient.PostAsync("api/factory", content);
var result = response.Content.ReadAsStringAsync().Result;
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
Assert.Contains("\"c\":200,\"m\":\"success\",\"d\":\"success\"", result);
}
public IHttpActionResult GetFactoryById(int id)
{
FactoryModel factoryModel = new FactoryModel();
try
{
FactoryModel.Format_Detail factory = factoryModel.GetById(id);
return(Content(HttpStatusCode.OK, factory));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public IHttpActionResult GetAllFactoryByCompanyId()
{
FactoryModel factoryModel = new FactoryModel();
try
{
int companyId = Global.GetCompanyIdFromToken();
List <FactoryModel.Format_Detail> factoryList = factoryModel.GetAllByCompanyId(companyId);
return(Content(HttpStatusCode.OK, factoryList));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public CodeOutput GenerateFactory()
{
if (!CanWriteFactory())
{
return(null);
}
var data = new FactoryModel
{
classModifier = Settings.DbContextClassModifiers,
contextName = Settings.DbContextName
};
var co = new CodeOutput(Settings.DbContextName + "Factory" + Settings.FileExtension, "Database context factory", GlobalUsings);
co.AddUsings(Template.DatabaseContextFactoryUsings(data));
co.AddCode(Template.Transform(Template.DatabaseContextFactory(), data));
return(co);
}
public static T ToObject <T>(DataTable dt, int Rowindex, AbstractDatabase Db, IUnityContainer container, ICacheManager cache, string pluginName, string unityname)
{
T obj = FactoryModel.GetObject <T>(Db, container, cache, pluginName, unityname);
if (Rowindex >= dt.Rows.Count)
{
return(obj);
}
//列名
string columnName;
//属性名
string propertyName;
//列数量
int column = dt.Columns.Count;
//属性数量
int propertyNum = obj.GetType().GetProperties().Length;
//遍历所有列
for (int i = 0; i < column; i++)
{
//遍历所有属性
for (int j = 0; j < propertyNum; j++)
{
columnName = dt.Columns[i].ColumnName.ToUpper();
propertyName = obj.GetType().GetProperties()[j].Name.ToUpper();
if (columnName == propertyName)
{
string fullName = dt.Rows[Rowindex][columnName].GetType().FullName;
object objectValue = dt.Rows[Rowindex][i];
//如果datatable中的对应项是空类型
if (fullName == "System.DBNull")
{
obj.GetType().GetProperties()[j].SetValue(obj, null, null);
}
else
{
obj.GetType().GetProperties()[j].SetValue(obj, objectValue, null);
}
}
}
}
return(obj);
}
public ActionResult Create(FactoryModel model)
{
if (ModelState.IsValid)
{
factoryService.Add(model);
factoryService.SaveChanges();
//var list = new SelectList(new List<SelectListItem>
//{
// new SelectListItem { Selected = true, Text = model.Name.ToString(), Value =model.Id.ToString()},
//});
var model2 = factoryService.GetQuery(q => q.Name == model.Name).FirstOrDefault();
TempData["FabrikaId"] = model2.Id;
TempData.Keep(key: "FabrikaId");
return(RedirectToAction("YeniKayit", "Account"));
}
return(View(model));
}
public static DominDriveDesignModel GetDominDriveDesignModel(FactoryModel element)
{
return DslModeling::DomainRoleInfo.GetLinkedElement(element, FactoryModelDomainRoleId) as DominDriveDesignModel;
}
public FactoryViewModel()
{
FactoryModel = new FactoryModel();
}
/// <summary>
/// Constructor
/// Creates a DominDriveDesignModelHasFactoryModels link in the same Partition as the given DominDriveDesignModel
/// </summary>
/// <param name="source">DominDriveDesignModel to use as the source of the relationship.</param>
/// <param name="target">FactoryModel to use as the target of the relationship.</param>
public DominDriveDesignModelHasFactoryModels(DominDriveDesignModel source, FactoryModel target)
: base((source != null ? source.Partition : null), new DslModeling::RoleAssignment[]{new DslModeling::RoleAssignment(DominDriveDesignModelHasFactoryModels.DominDriveDesignModelDomainRoleId, source), new DslModeling::RoleAssignment(DominDriveDesignModelHasFactoryModels.FactoryModelDomainRoleId, target)}, null)
{
}
public static void SetDominDriveDesignModel(FactoryModel element, DominDriveDesignModel newDominDriveDesignModel)
{
DslModeling::DomainRoleInfo.SetLinkedElement(element, FactoryModelDomainRoleId, newDominDriveDesignModel);
}
