private void SaveDvhIndices()
{
foreach (var dvhObjectivesViewModel in DvhObjectivesViewModels)
{
var planInfo = new PlanInfo
{
PatientId = PatientId,
PatientName = PatientName,
CourseId = dvhObjectivesViewModel.CourseId,
PlanId = dvhObjectivesViewModel.PlanId,
// cGy to Gy
PrescribedDose = dvhObjectivesViewModel.PrescribedDose / 100,
MaxDose = dvhObjectivesViewModel.MaxDose
};
string planFolderPath = Path.Combine(PlanCheckerDirectoryPath, Path.Combine(PatientId, Path.Combine(planInfo.PlanId, "PlanCheckData")));
if (!Directory.Exists(planFolderPath))
{
Directory.CreateDirectory(planFolderPath);
}
var dvhObjectives = dvhObjectivesViewModel.DvhObjectives;
if (dvhObjectives.Count > 0)
{
var originalProtocolId = dvhObjectives[0].OriginalProtocolId;
DvhObjective.WriteObjectivesToFile(dvhObjectives.ToList(), originalProtocolId, Path.Combine(planFolderPath, "DvhInfo_sjis.csv"), planInfo);
}
else
{
MessageBox.Show("No Objective");
}
}
return;
}
/// \brief This method InsertPlanInfo for user
/// \details <b>Details</b>
/// This method will insert plan info when finishing order
/// \return void
public bool InsertPlanInfo(PlanInfo plan)
{
using (var myConn = new MySqlConnection(connectionString))
{
try
{
const string sqlStatement = @" INSERT INTO planinfo (planID, orderID, startCityID, endCityID, workingTime, distance)
VALUES (@planID, @orderID, @startCityID, @endCityID, @workingTime, @distance); " ;
var myCommand = new MySqlCommand(sqlStatement, myConn);
myCommand.Parameters.AddWithValue("@planID", plan.planID);
myCommand.Parameters.AddWithValue("@orderID", plan.orderID);
myCommand.Parameters.AddWithValue("@startCityID", plan.startCityID);
myCommand.Parameters.AddWithValue("@endCityID", plan.endCityID);
myCommand.Parameters.AddWithValue("@workingTime", plan.workingTime);
myCommand.Parameters.AddWithValue("@distance", plan.distance);
myConn.Open();
myCommand.ExecuteNonQuery();
Log.Info("SQL Execute: " + sqlStatement);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Log.Error("SQL Error" + ex.Message);
return(false);
}
}
}
public InfoResponse <string> Post([FromBody] PlanInfo plan)
{
InfoResponse <string> response = new InfoResponse <string>();
response.Data = PlanService.Current.SavePlanInfo(plan);
return(response);
}
public IList <PlanInfo> GetPlanList(int sid, out string msg)
{
var cptypeInfo = CpTypeSIdMapTool.GeTypeSIdMaps(sid);
var freePlanLibs =
_lotteryPlanLibRepository.GetAllList(p => p.SId == sid &&
p.State != 3 &&
string.IsNullOrEmpty(p.VCode))
.OrderByDescending(p => p.State)
.ThenByDescending(p => p.CreateTime).Take(_freePlanNum).ToList();
if (freePlanLibs.Count <= 0)
{
LogHelper.Logger.Error("用户尝试获取sid为" + sid + "的计划，但是计划库并没有改彩种的有效计划");
throw new Exception("计划库中没有存在该彩种的计划，请稍后再尝试获取!");
}
var freePlanInfos = new List <PlanInfo>();
var count = 1;
foreach (var planlib in freePlanLibs)
{
var planInfo = new PlanInfo()
{
PlanName = m_planNamePrefix + count,
PlanUrl = string.Format("{0}/app/{1}/planshare/{2}", m_planServiceAddress, cptypeInfo.CpType, planlib.Id)
};
count++;
freePlanInfos.Add(planInfo);
}
msg = "OK";
return(freePlanInfos);
}
/// \brief This method UpdatePlanInfo for user
/// \details <b>Details</b>
/// This method will update plan info when finishing order
/// \return void
public bool UpdatePlanInfo(PlanInfo plan)
{
using (var myConn = new MySqlConnection(connectionString))
{
try
{
const string sqlStatement = @" UPDATE products
SET CategoryId = @CategoryId,
UnitPrice = @UnitPrice,
UnitsInStock = @UnitsInStock
WHERE ProductID = @ProductID; " ;
var myCommand = new MySqlCommand(sqlStatement, myConn);
myCommand.Parameters.AddWithValue("@ProductID", plan.planID);
//myCommand.Parameters.AddWithValue("@CategoryId", plan.tripID);
myCommand.Parameters.AddWithValue("@UnitPrice", plan.startCityID);
myCommand.Parameters.AddWithValue("@UnitsInStock", plan.endCityID);
myCommand.Parameters.AddWithValue("@UnitsInStock", plan.workingTime);
myCommand.Parameters.AddWithValue("@UnitsInStock", plan.distance);
myConn.Open();
myCommand.ExecuteNonQuery();
Log.Info("SQL Execute: " + sqlStatement);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Log.Error("SQL Error" + ex.Message);
return(false);
}
}
}
void FillParameters(MySqlCommand cmd, PlanInfo item)
{
MySqlParameter paramDate = new MySqlParameter("입력날짜", MySqlDbType.DateTime);
paramDate.Value = item.입력날짜;
MySqlParameter paramLine = new MySqlParameter("라인", MySqlDbType.VarChar, 15);
paramLine.Value = item.라인;
MySqlParameter paramGoal = new MySqlParameter("목표수", MySqlDbType.Int32);
paramGoal.Value = item.목표수;
MySqlParameter paramSituation = new MySqlParameter("상황", MySqlDbType.VarChar, 20);
paramSituation.Value = item.상황;
MySqlParameter paramProduct = new MySqlParameter("제품명", MySqlDbType.VarChar, 20);
paramProduct.Value = item.제품명;
MySqlParameter paramID = new MySqlParameter("ID", MySqlDbType.Int16);
paramID.Value = item.ID;
cmd.Parameters.Add(paramDate);
cmd.Parameters.Add(paramLine);
cmd.Parameters.Add(paramGoal);
cmd.Parameters.Add(paramSituation);
cmd.Parameters.Add(paramProduct);
cmd.Parameters.Add(paramID);
}
public void Planner_Make_Plan()
{
bool flag = false;
//Order Info
Order order = new Order();
order.orderID = "ORD20191119001";
//Planinfo
PlanInfo plan = new PlanInfo();
var planResult = plan.GetPlanInfo(order.orderID);
//set Order.carrierID with selected carrierID
if (planResult[0] != null)
{
plan.command = "INSERT";
//assign data from table
plan.planID = "PLAN" + planResult[0].orderID;
plan.orderID = planResult[0].orderID;
plan.startCityID = planResult[0].startCityID;
plan.endCityID = planResult[0].endCityID;
plan.distance = planResult[0].distance;
plan.workingTime = planResult[0].workingTime;
flag = plan.Save();
}
else
{
flag = false;
}
Assert.AreEqual(true, flag);
}
public string SavePlanInfo(PlanInfo plan)
{
var db = Utils.GetDb();
PlanDac planDac = new PlanDac(db);
db.BeginTransaction();
try
{
if (planDac.IsExistPlanInfo(plan))
{
planDac.UpdatePlanInfo(plan);
}
else
{
plan.ID = Guid.NewGuid().ToString();
planDac.AddPlanInfo(plan);
}
planDac.SavePlanItems(plan);
planDac.SaveCarbonCopyRecipients(plan);
db.Commit();
return(plan.ID);
}
catch (Exception e)
{
db.Rollback();
throw;
}
}
public string GetDescription(Transaction transaction, PlanInfo plan, SubscriptionInfo subscription)
{
switch (transaction.ETransactionType)
{
case ETransactionType.Authentication:
return(String.Format(WebFace.Invoice.Resources.Messages.AUTHENTICATION_DESCRIPTION,
plan.Name,
subscription.From.ToString(DATE_FORMAT),
subscription.Till.ToString(DATE_FORMAT)));
case ETransactionType.Preauthorization:
return(String.Format(WebFace.Invoice.Resources.Messages.PREAUTHORIZATION_DESCRIPTION,
plan.Name,
subscription.From.ToString(DATE_FORMAT),
subscription.Till.ToString(DATE_FORMAT)));
case ETransactionType.PreauthCharge:
return(String.Format(WebFace.Invoice.Resources.Messages.PREAUTHCHARGE_DESCRIPTION,
plan.Name,
subscription.From.ToString(DATE_FORMAT),
subscription.Till.ToString(DATE_FORMAT)));
case ETransactionType.PreauthCancelation:
return(String.Format(WebFace.Invoice.Resources.Messages.PREAUTHCANCELATION_DESCRIPTION,
plan.Name,
subscription.From.ToString(DATE_FORMAT),
subscription.Till.ToString(DATE_FORMAT)));
default: return(string.Empty);
}
}
public async Task <IActionResult> PutPlanInfo(int LineId, PlanInfo planInfo)
{
if (LineId != planInfo.LineInfoID)
{
return(BadRequest());
}
_context.Entry(planInfo).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PlanInfoExists(planInfo.PlanInfoID))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <PlanInfo> > PostPlanInfo(PlanInfo planInfo)
{
_context.Plans.Add(planInfo);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPlanInfo", new { id = planInfo.PlanInfoID }, planInfo));
}
public void ShowWindow(PlanInfo planInfo)
{
this.planInfo = planInfo;
this.characterName = planInfo.characterName;
UpdateWindow();
ShowWindow();
}
public ActionResult Edit(int id)
{
ViewBag.listPrizeType = Common.EnumToSelectListItem(typeof(SysEnum.PrizeType));
PlanInfo info = PlanBLL.GetList(p => p.ID == id).FirstOrDefault();
return(View(info));
}
internal void SaveCarbonCopyRecipients(PlanInfo plan)
{
DeletePlanCarbonCopyRecipientInfo(plan.ID);
foreach (SysUser user in plan.CarbonCopyRecipient)
{
SaveCarbonCopyRecipient(plan.ID, user.ID);
}
}
public void Insert(PlanInfo item)
{
string text = "INSERT INTO Plan VALUES(@입력날짜, @라인, @목표수, @상황, @제품명, @ID, null)";
MySqlCommand cmd = new MySqlCommand(text, _MyConnection);
FillParameters(cmd, item);
cmd.ExecuteNonQuery();
}
public void DeleteDB(PlanInfo item)
{
string text = "DELETE FROM Plan WHERE ID=@ID";
MySqlCommand cmd = new MySqlCommand(text, _MyConnection);
FillParameters(cmd, item);
cmd.ExecuteNonQuery();
}
public void UpdateID(PlanInfo item)
{
string text = "UPDATE Plan SET 상황 = '가동중' WHERE ID = @ID";
MySqlCommand cmd = new MySqlCommand(text, _MyConnection);
FillParameters(cmd, item);
cmd.ExecuteNonQuery();
}
public void Refresh()
{
List <ToggleInfo> list = new List <ToggleInfo>();
if (tagCategoryMap == null)
{
int building_index = 0;
tagCategoryMap = new Dictionary <Tag, HashedString>();
tagOrderMap = new Dictionary <Tag, int>();
if (TUNING.BUILDINGS.PLANORDER.Count > 12)
{
DebugUtil.LogWarningArgs("Insufficient keys to cover root plan menu", "Max of 12 keys supported but TUNING.BUILDINGS.PLANORDER has " + TUNING.BUILDINGS.PLANORDER.Count);
}
toggleEntries.Clear();
for (int i = 0; i < TUNING.BUILDINGS.PLANORDER.Count; i++)
{
PlanInfo planInfo = TUNING.BUILDINGS.PLANORDER[i];
Action hotkey = (Action)((i >= 12) ? 247 : (36 + i));
string icon = iconNameMap[planInfo.category];
string str = HashCache.Get().Get(planInfo.category).ToUpper();
ToggleInfo toggleInfo = new ToggleInfo(UI.StripLinkFormatting(Strings.Get("STRINGS.UI.BUILDCATEGORIES." + str + ".NAME")), icon, planInfo.category, hotkey, Strings.Get("STRINGS.UI.BUILDCATEGORIES." + str + ".TOOLTIP"), string.Empty);
list.Add(toggleInfo);
PopulateOrderInfo(planInfo.category, planInfo.data, tagCategoryMap, tagOrderMap, ref building_index);
List <BuildingDef> list2 = new List <BuildingDef>();
foreach (BuildingDef buildingDef in Assets.BuildingDefs)
{
HashedString value;
if (!buildingDef.Deprecated && tagCategoryMap.TryGetValue(buildingDef.Tag, out value) && !(value != planInfo.category))
{
list2.Add(buildingDef);
}
}
toggleEntries.Add(new ToggleEntry(toggleInfo, planInfo.category, list2, planInfo.hideIfNotResearched));
}
Setup(list);
toggles.ForEach(delegate(KToggle to)
{
ImageToggleState[] components = to.GetComponents <ImageToggleState>();
ImageToggleState[] array = components;
foreach (ImageToggleState imageToggleState in array)
{
if ((UnityEngine.Object)imageToggleState.TargetImage.sprite != (UnityEngine.Object)null && imageToggleState.TargetImage.name == "FG" && !imageToggleState.useSprites)
{
imageToggleState.SetSprites(Assets.GetSprite(imageToggleState.TargetImage.sprite.name + "_disabled"), imageToggleState.TargetImage.sprite, imageToggleState.TargetImage.sprite, Assets.GetSprite(imageToggleState.TargetImage.sprite.name + "_disabled"));
}
}
to.GetComponent <KToggle>().soundPlayer.Enabled = false;
});
for (int j = 0; j < toggleEntries.Count; j++)
{
ToggleEntry value2 = toggleEntries[j];
value2.CollectToggleImages();
toggleEntries[j] = value2;
}
}
}
public ActionResult Create(PlanInfo info)
{
info.Enable = true;
PlanBLL.Create(info);
if (info.ID > 0)
{
return(Json(new APIJson(0, "添加成功")));
}
return(Json(new APIJson(-1, "添加失败")));
}
internal bool IsExistPlanInfo(PlanInfo plan)
{
if (string.IsNullOrEmpty(plan.ID))
{
return(false);
}
var result = db.ExecuteScalar(@"select count(1) from plan where id={0}", plan.ID);
return(Convert.ToInt32(result) > 0);
}
internal void SavePlanItems(PlanInfo plan)
{
string deletePlanItem = "delete from planitem where planid={0}";
db.ExecSqlStatement(deletePlanItem, plan.ID);
foreach (PlanItem item in plan.PlanItems)
{
SavePlanItem(plan.ID, item);
}
}
public string NewProductionPlan(PlanInfo obj)
{
var jsonObj = Newtonsoft.Json.JsonConvert.SerializeObject(obj);
using (var content = new StringContent(jsonObj, Encoding.UTF8, "application/json"))
{
var response = _httpClient.PostAsync("Plan/CreatePlan", content).Result;
var res = response.Content.ReadAsStringAsync().Result;
//Response<object> ret = JsonConvert.DeserializeObject<Response<object>>(res);
return(res);
}
}
} //cell 더블클릭 이벤트 추가예정
private void button2_Click_1(object sender, EventArgs e) //예약(O)
{
MySqlConnection myConnection = new MySqlConnection(connectionString);
myConnection.Open();
int ID = 0;
try
{
PlanInfoDAC dac = new PlanInfoDAC(myConnection);
DataTable dt = new DataTable();
dt = dac.SelectMaxId().Tables[0];
if (dt.Rows[0][0].ToString() == "")
{
ID = 1;
}
else
{
ID = Convert.ToInt16(dt.Rows[0][0].ToString()) + 1;
}
PlanInfo item = new PlanInfo();
item.입력날짜 = DateTime.Now;
item.라인 = SelectProductionLine.Text;
item.목표수 = Convert.ToInt16(Line_num.Text);
item.상황 = "예약";
item.제품명 = Line_Product.Text;
item.ID = ID;
dac.Insert(item);
LinePlanGrid.DataSource = dac.SelectSituation("예약").Tables[0];
LinePlanGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
MessageBox.Show("입력이 완료되었습니다.");
myConnection.Close();
}
catch (Exception)
{
MessageBox.Show("제품명 , 제품 수량 , 생산 라인을 입력해주세요.");
}
finally
{
if (myConnection != null && myConnection.State == System.Data.ConnectionState.Open)
{
myConnection.Close();
}
}
Line_num.Clear();
}
internal PlanInfo GetPlanBaseInfo(string planInfoID)
{
PlanInfo plan = new PlanInfo();
StringBuilder stringBuilder = new StringBuilder($@"select a.id, a.NAME, b.NAME AS periodname,b.id as periodid, b.alias as periodalias, b.parentid as periodparentid, c.name as typename, c.code AS typecode, a.mainrecipient, a.state, a.stage, a.tenantid, a.userid, a.createdtime, a.lastmodifiedtime,a.approvalinstance, a.plandefineid
from plan a left join period b on b.id = a.periodid left join periodtype c on c.id = b.typeid where a.tenantid = '{Utils.GetTenantId()}' and a.id = '{planInfoID}'");
var ds = db.ExecuteDataSet(stringBuilder.ToString());
if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count > 0)
{
plan = AssamblyPlanInfo(ds.Tables[0].Rows[0]);
}
return(plan);
}
public ActionResult Delete(int id)
{
PlanInfo info = PlanBLL.GetList(p => p.ID == id).FirstOrDefault();
if (null == info)
{
return(Json(new APIJson(-1, "删除失败，参数有误", info)));
}
if (PlanBLL.Delete(info))
{
return(Json(new APIJson(0, "删除成功", info)));
}
return(Json(new APIJson(-1, "删除失败，请重试", info)));
}
private void Save_Trip_Button_Click(object sender, RoutedEventArgs e)
{
//check if the same information with orderID in planinfo
PlanInfo planinfo = new PlanInfo();
var planList = planinfo.GetPlanID(txtOrderID.Text);
if (planList.Count == 1)
{
MessageBox.Show("Trip's Data is alread existed. You need to check this.", "Duplication Trip Data");
}
else
{
Insert_TripData(selectedTrips);
}
}
public InfoResponse <PlanInfo> Get(string planID)
{
PlanInfo planInfo = PlanService.Current.Get(planID);
InfoResponse <PlanInfo> response = new InfoResponse <PlanInfo>();
if (planInfo != null && !string.IsNullOrEmpty(planInfo.ID))
{
response.Data = planInfo;
}
else
{
response.Code = 204;
response.Msg = "The Plan does not exist";
}
return(response);
}
public uint game_kind; //对于手机类，请指定具体的游戏种类
public int CompareTo(object right) //list.Sort以后按照从小到大的顺序排
{
PlanInfo other = (PlanInfo)right;
if (this.plan_orders > other.plan_orders)
{
return(1);
}
else if (this.plan_orders == other.plan_orders)
{
return(0);
}
else
{
return(-1);
}
}
public void CopyBuildingOrder(Building building)
{
foreach (PlanInfo item in TUNING.BUILDINGS.PLANORDER)
{
PlanInfo current = item;
foreach (string item2 in (List <string>)current.data)
{
if (building.Def.PrefabID == item2)
{
OpenCategoryByName(HashCache.Get().Get(current.category));
OnSelectBuilding(ActiveToggles[building.Def].gameObject, building.Def);
productInfoScreen.materialSelectionPanel.SelectSourcesMaterials(building);
break;
}
}
}
}
public async Task <bool> DiscardRemainOrder(PlanInfo Plan)
{
var jsonObj = Newtonsoft.Json.JsonConvert.SerializeObject(Plan);
using (var content = new StringContent(jsonObj, Encoding.UTF8, "application/json"))
{
try
{
var ret = await _httpClient.PutAsync("Orders/DiscardRemainOrder/", content);
return(ret.IsSuccessStatusCode);
}
catch (Exception)
{
return(false);
}
}
}
