private void btnSave_Click(object sender, EventArgs e)
{
oPosition = new DataAccess.Position();
if (tbxPosition.Text.Trim() != String.Empty)
{
oMPosition = new Model.Position();
oMPosition.ID = eVariable.sID;
oMPosition.POSITION = tbxPosition.Text;
oMPosition.STATUS = chkStatus.Checked == true ? "ACTIVE" : "INACTIVE";
if (TransactionType == eVariable.TransactionType.EDIT)
{
oPosition.UpdatePosition(oMPosition);
}
else
{
if (oPosition.IsPositionExists(tbxPosition.Text))
{
oFrmMsgBox = new frmMessageBox("RECORD ALREADY EXISTS");
oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
oPosition = new DataAccess.Position();
oPosition.InsertPosition(oMPosition);
}
oFrmMsgBox = new frmMessageBox("RECORD SUCCESSFULLY SAVED");
oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
LoadPosition();
eVariable.ClearText(panel3);
TransactionType = eVariable.TransactionType.ADD;
}
}
/// <summary>
/// 通过编号找到库位.
/// </summary>
/// <param name="nnum">库位编号.</param>
public Model.Position getPositionByNum(string nnum)
{
Model.Position posi = null;
string sqltext = "select * from position where positionNum=@positionNum";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@positionNum", nnum);
para.Add(sqlpara1);
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para);
while (sdr.Read())
{
posi = new Model.Position();
posi.PositionNum = sdr["positionNum"].ToString();
posi.RoomNum = sdr["roomNum"].ToString();
posi.ChestNum = sdr["chestNum"].ToString();
posi.PositiontypeId = sdr["positionTypeId"].ToString();
posi.GoodsTypes = sdr["goodsTypes"].ToString();
posi.Remark = sdr["remark"].ToString();
posi.CreateTime = DateTime.Parse(sdr["createTime"].ToString());
posi.UpdateTime = DateTime.Parse(sdr["updateTime"].ToString());
posi.M = sdr["M"].ToString();
posi.Height = sdr["Height"].ToString();
}
sdr.Close();
DBTools.DBClose();
return(posi);
}
protected void Button200_Click(object sender, EventArgs e)
{
Model.Position delete = new Model.Position();
int x = Convert.ToInt32(Session["e"]);
delete.PositionNum = GridView1.Rows[x].Cells[1].Text;
Warehouse.Tools.queryV qu = new Tools.queryV();
Warehouse.Tools.apartV qp = new Tools.apartV();
string chestNum = qu.query("select chestNum from Position where PositionNum='" + delete.PositionNum + "' ");
string positionM = qu.query("select M from Position where PositionNum='" + delete.PositionNum + "' ");
string M = qu.query("select M from Chest where chestNum='" + chestNum + "' ");
bool yy = new DAL.PositionDAO().deletePositionByNum(delete.PositionNum);
if (yy)
{
Warehouse.Tools.updateChestM up = new Tools.updateChestM();
double bb = (Convert.ToDouble(qp.apart(M)) + Convert.ToDouble(qp.apart(positionM)));
up.update((bb.ToString() + "平方米"), chestNum);
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功！');", true);
ideas.Style["display"] = "none";
pg.Refresh("select num,positionNum,chestNum,roomNum,positionTypeId,goodsTypes,M,remark from Position", "positionNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败！');", true);
ideas.Style["display"] = "none";
}
}
void AddItemOnClick(object obj)
{
Model.Position newPositions;
using (SqlConnection con = new SqlConnection(GValues.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand())
{
newPositions = new Model.Position();
newPositions.itemId = 0;
newPositions.xcount = 0;
newPositions.currencyId = Model.Position.lastCurrency;
newPositions.xprice = 0;
newPositions.isAvalForEdit = true;
command.Connection = con;
command.CommandText = " INSERT INTO document_items(xdocument, item, ref_dimensions, xcount, currency, xprice, ref_status) " +
" VALUES(@xdocument, @item, @ref_dimensions, @xcount, @currency, @xprice, @ref_status ); " +
" SELECT SCOPE_IDENTITY();";
command.Parameters.Add("xdocument", SqlDbType.Int).Value = DataModel.CurDocument.Id;
command.Parameters.Add("item", SqlDbType.Int).Value = newPositions.itemId;
command.Parameters.Add("ref_dimensions", SqlDbType.Int).Value = newPositions.dimensionId;
command.Parameters.Add("xcount", SqlDbType.Decimal).Value = newPositions.xcount;
command.Parameters.Add("currency", SqlDbType.Decimal).Value = newPositions.currencyId;
command.Parameters.Add("xprice", SqlDbType.Decimal).Value = newPositions.xprice;
command.Parameters.Add("ref_status", SqlDbType.Int).Value = 1;
newPositions.id = (decimal)command.ExecuteScalar();
}
}
DataModel.CurDocument.DocumentPositions.Add(newPositions);
newPositions = null;
}
/// <summary>
/// 获取所有的库位.
/// </summary>
/// <returns>库位对象泛型集合.</returns>
public List <Model.Position> getAllPositions()
{
List <Model.Position> posi = new List <Model.Position>();
string sqltext = "select * from position";
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ());
while (sdr.Read())
{
Model.Position p = new Model.Position();
p.PositionNum = sdr["positionNum"].ToString();
p.RoomNum = sdr["roomNum"].ToString();
p.ChestNum = sdr["chestNum"].ToString();
p.PositiontypeId = sdr["positionTypeId"].ToString();
p.GoodsTypes = sdr["goodsTypes"].ToString();
p.Remark = sdr["remark"].ToString();
p.CreateTime = DateTime.Parse(sdr["createTime"].ToString());
p.UpdateTime = DateTime.Parse(sdr["updateTime"].ToString());
p.M = sdr["M"].ToString();
p.Height = sdr["Height"].ToString();
p.Rest = sdr["Rest"].ToString();
posi.Add(p);
}
sdr.Close();
DBTools.DBClose();
return(posi);
}
public void Run(Model.MlbStatsContext context)
{
var url = Feeds.PositionsFeed.GetFeedUrl();
var rawJson = JsonUtility.GetRawJsonFromUrl(url);
var feed = Feeds.PositionsFeed.FromJson(rawJson);
var dbPositions = context.Positions.ToDictionary(x => x.PositionAbbr);
foreach (var feedPosition in feed)
{
if (!dbPositions.TryGetValue(feedPosition.Abbrev, out Model.Position dbPosition))
{
dbPosition = new Model.Position
{
PositionAbbr = feedPosition.Abbrev,
ShortName = feedPosition.ShortName,
FullName = feedPosition.FullName,
FormalName = feedPosition.FormalName,
DisplayName = feedPosition.DisplayName,
PositionCode = feedPosition.Code,
IsFielder = feedPosition.Fielder,
IsPitcher = feedPosition.Pitcher,
IsOutfield = feedPosition.Outfield,
PositionType = feedPosition.Type
};
dbPositions.Add(dbPosition.PositionAbbr, dbPosition);
context.Positions.Add(dbPosition);
}
else
{
; // TODO: ADD NO-CHANGE VALIDATION LOGIC
}
}
context.SaveChanges();
}
/// <summary>
/// 添加职务（确定按钮）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImageButton1_Click(object sender, EventArgs e)
{
try
{
if (TextBox1.Text.Trim() != "")
{
Maticsoft.Model.Position zhiwu = new Model.Position();
zhiwu.name = TextBox1.Text.Trim();
zhiwu.beizhu = TextBox2.Text.Trim();
int a = zw.Add(zhiwu);
if (a > 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加成功！');</script>");
bind(sql);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加失败！');</script>");
bind(sql);
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('职务名称不能为空！');</script>");
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv1();</script>");
}
}
catch (Exception ee)
{
//Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>");
}
}
public frmSearch()
{
InitializeComponent();
oMStudent = new Model.Student();
oMParty = new Model.Party();
oMPosition = new Model.Position();
eVariable.DisableTextPanelEnterKey(panel3);
eVariable.DisableKeyPress(cboSearch);
}
public void ConvertAccidentalTest_Position(string meipos, Model.Position convertedPos)
{
if (meipos != null)
{
meiaccid.SetAccidPos(meipos);
}
AccidentalConverter.ConvertAccidental(convertedAccid, meiaccid);
Assert.AreEqual(convertedPos, convertedAccid.AccidentalPosition);
}
async void OnNewSightClicked(object sender, EventArgs args)
{
Model.Position currentPosition = BindingContext as Model.Position;
Sight newSight = new Sight(currentPosition.ID);
await AlmicantaratXF.Views.App.PositionsSightsDB.SaveSightAsync(newSight);
/*
* await Navigation.PushAsync(new SightPage
* {
* BindingContext = newSight
* });
*/
await Navigation.PushAsync(new SightPage(newSight, currentPosition));
}
public static ChangedEnum WhatsChanged(cAlgo.API.Position Position)
{
Model.Position LocalPosition = GetByID(Position.Id);
if (LocalPosition == null)
{
return(ChangedEnum.Status);
}
// else if (LocalPosition.TakeProfit <> (decimal)Position.TakeProfit )
// return ChangedEnum.TakeProfit
return(ChangedEnum.Unknown);
}
void DatagridSelect(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgPosition.Rows.Count > 0 && e.RowIndex >= 0)
{
oMPosition = new Model.Position();
oMPosition.ID = dgPosition.Rows[e.RowIndex].Cells[0].Value.ToString().Trim();
oMPosition.POSITION = dgPosition.Rows[e.RowIndex].Cells[1].Value.ToString().Trim();
oMPosition.STATUS = dgPosition.Rows[e.RowIndex].Cells[2].Value.ToString().Trim();
}
}
catch (Exception ex)
{
}
}
public void insertPosition(Model.Position position)
{
try
{
if (null == position)
{
return;
}
IDAL.IPosition dal = DALFactory.Position.Create();
dal.insertPosition(position);
}
catch (Exception e)
{
throw e;
}
}
async void OnDelete(object sender, EventArgs args)
{
bool answer = await DisplayAlert(
rm.GetString("warning"),
rm.GetString("messageDeletePosition"),
rm.GetString("deleteAnyway"),
rm.GetString("cancel"));
//System.Diagnostics.Debug.WriteLine("Answer: " + answer);
if (answer)
{
Model.Position currentPosition = BindingContext as Model.Position;
//TODO delete sights
AlmicantaratXF.Views.App.PositionsSightsDB.DeleteSights(currentPosition.ID);
await AlmicantaratXF.Views.App.PositionsSightsDB.DeletePositionAsync(currentPosition);
await Navigation.PopAsync();
}
}
protected void Button66_Click(object sender, EventArgs e)
{
Model.Outout add = new Model.Outout();
if (Button66.Text == "增加")
{
if (Image1.ImageUrl == "~/Image/对号.png" && Image2.ImageUrl == "~/Image/对号.png" && Image3.ImageUrl == "~/Image/对号.png" && Image4.ImageUrl == "~/Image/对号.png" && Image5.ImageUrl == "~/Image/对号.png" && Image6.ImageUrl == "~/Image/对号.png" && Image7.ImageUrl == "~/Image/对号.png" && Image8.ImageUrl == "~/Image/对号.png")
{
Warehouse.Tools.queryV qq = new Tools.queryV();
DAL.Query quu = new DAL.Query();
int n = quu.query("Outout");
add.Num = n + 1;
add.OuID = TextBox11.Text;
add.GoodsNum = TextBox12.Text;
add.PositionNum = TextBox9.Text;
add.OutAmount = Convert.ToDouble(TextBox2.Text);
add.BatchNum = TextBox3.Text;
add.Date = Convert.ToDateTime(TextBox4.Text);
add.UserId = qu.query("select staffNum from Staff where staffName='" + TextBox5.Text + "'");
add.Remark = TextBox6.Text;
bool xx = new DAL.OutoutDAO().addOut(add);
if (xx)
{
Model.Amount update = new Model.Amount();
update.Amounts = Convert.ToDouble(Session["max"].ToString()) - Convert.ToDouble(add.OutAmount);
double d = Convert.ToDouble(Session["V"].ToString()) / Convert.ToDouble(Session["max"].ToString());
update.V = (update.Amounts * d).ToString();
update.GoodsNum = TextBox12.Text;
update.PositionNum = TextBox9.Text;
update.Vp = d.ToString();
bool yy = new DAL.AmountDAO().update(update);
if (yy)
{
double rest = Convert.ToDouble(qu.query("select Rest from Position where positionNum='" + TextBox9.Text + "'"));
Model.Position Update = new Model.Position();
Update.Rest = (rest + d * add.OutAmount).ToString();
Update.PositionNum = TextBox9.Text;
bool cc = new DAL.PositionDAO().update(Update);
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='出库登记.aspx'", true);
}
}
}
}
/// <summary>
/// 修改弹窗赋值
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButton1_Click(object sender, EventArgs e)
{
try
{
//获取button 控件
LinkButton lb = (LinkButton)sender;
//获取传过来的commwntid
int id = Convert.ToInt32(lb.CommandArgument);
Model.Position po = zw.GetModel(id);
Label1.Text = po.id.ToString();
TextBox4.Text = po.name;
TextBox5.Text = po.beizhu;
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>");
}
catch (Exception ee)
{
//Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('修改弹窗异常 " + ee.Message + "');</script>");
}
}
/// <summary>
/// 更新某个库位.库位编号不可更改.
/// </summary>
/// <param name="posi">库位对象.</param>
public bool update(Model.Position posi)
{
string sqltext = "update Position set rest=@rest where positionNum=@positionNum";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@positionNum", posi.PositionNum);
SqlParameter sqlpara11 = new SqlParameter("@Rest", posi.Rest);
para.Add(sqlpara1);
para.Add(sqlpara11);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加一个库位.库位编号是主键.
/// </summary>
/// <param name="posi">库位对象.</param>
/// <returns>通过布尔类型判断操作是否成功.</returns>
public bool addPosition(Model.Position posi)
{
string sqltext = "insert position(num,positionNum,chestNum,roomNum,positionTypeId,goodsTypes,M,Height,Rest,remark,createTime,updateTime) values(@num,@positionNum,@chestNum,@roomNum,@positionTypeId,@goodsTypes,@M,@Height,@Rest,@remark,@createTime,@updateTime)";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara = new SqlParameter("@num", posi.Num);
SqlParameter sqlpara1 = new SqlParameter("@positionNum", posi.PositionNum);
SqlParameter sqlpara2 = new SqlParameter("@chestNum", posi.ChestNum);
SqlParameter sqlpara3 = new SqlParameter("@roomNum", posi.RoomNum);
SqlParameter sqlpara4 = new SqlParameter("@positionTypeId", posi.PositiontypeId);
SqlParameter sqlpara5 = new SqlParameter("@goodsTypes", posi.GoodsTypes);
SqlParameter sqlpara51 = new SqlParameter("@M", posi.M);
SqlParameter sqlpara52 = new SqlParameter("@Height", posi.Height);
SqlParameter sqlpara53 = new SqlParameter("@Rest", posi.Rest);
SqlParameter sqlpara6 = new SqlParameter("@remark", posi.Remark);
SqlParameter sqlpara7 = new SqlParameter("@createTime", posi.CreateTime.ToString());
SqlParameter sqlpara8 = new SqlParameter("@updateTime", posi.UpdateTime.ToString());
para.Add(sqlpara);
para.Add(sqlpara1);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara51);
para.Add(sqlpara52);
para.Add(sqlpara53);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
public void insertPosition(Model.Position position)
{
String sql = "";
try
{
if (position.Task_id < 0)
{
sql = " insert into Position "
+ " (LATITUDE,LONGITUDE,RECEIVETIME,USERNAME,PATROLER_ID,TASK_ID)VALUES("
+ position.Latitude + ","
+ position.Longitude + ","
+ "to_date('" + position.ReceiveTime.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss')" + ","
+ "'" + position.Username + "',"
+ position.Patroler_id + ","
+ position.Task_id + ")";
}
else
{
sql = " insert into Position "
+ " (LATITUDE,LONGITUDE,RECEIVETIME,USERNAME,PATROLER_ID)VALUES("
+ position.Latitude + ","
+ position.Longitude + ","
+ "to_date('" + position.ReceiveTime.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss')" + ","
+ "'" + position.Username + "',"
+ position.Patroler_id + ")";
}
OracleParameter[] parms = null;
string strCnn = OracleHelper.ConnectionStringOrderDistributedTransaction;
using (OracleConnection cnn = new OracleConnection(strCnn))
{
OracleHelper.ExecuteNonQuery(cnn, CommandType.Text, sql, parms);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新某个库位.库位编号不可更改.
/// </summary>
/// <param name="posi">库位对象.</param>
public bool updatePosition(Model.Position posi)
{
string sqltext = "update position set roomNum=@roomNum,chestNum=@chestNum,positionTypeId=@positionTypeId,goodsTypes=@goodsTypes,remark=@remark,createTime=@createTime,updateTime=@updateTime,M=@M,Height=@Height where positionNum=@positionNum";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@positionNum", posi.PositionNum);
SqlParameter sqlpara2 = new SqlParameter("@roomNum", posi.RoomNum);
SqlParameter sqlpara3 = new SqlParameter("@chestNum", posi.ChestNum);
SqlParameter sqlpara4 = new SqlParameter("@positionTypeId", posi.PositiontypeId);
SqlParameter sqlpara5 = new SqlParameter("@goodsTypes", posi.GoodsTypes);
SqlParameter sqlpara6 = new SqlParameter("@remark", posi.Remark);
SqlParameter sqlpara7 = new SqlParameter("@createTime", posi.CreateTime.ToString());
SqlParameter sqlpara8 = new SqlParameter("@updateTime", posi.UpdateTime.ToString());
SqlParameter sqlpara9 = new SqlParameter("@M", posi.M);
SqlParameter sqlpara10 = new SqlParameter("@Height", posi.Height);
SqlParameter sqlpara11 = new SqlParameter("@Rest", posi.Rest);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
para.Add(sqlpara1);
para.Add(sqlpara9);
para.Add(sqlpara10);
para.Add(sqlpara11);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
public static void UpdatePositions(IAccount Account, cAlgo.API.Positions Positions)
{
// Check for any open Positions that are no longer open in cTrader...
List <Model.Position> CurrentOpenPositions = Business.Positions.GetByAccountID(Account.Number, "Opened");
foreach (Model.Position LocalPosition in CurrentOpenPositions)
{
bool ClosedExternally = true;
foreach (cAlgo.API.Position AlgoP in Positions)
{
if (LocalPosition.ID == AlgoP.Id)
{
ClosedExternally = false;
}
}
if (ClosedExternally)
{
LocalPosition.Status = "Closed";
Business.Positions.Save(LocalPosition);
//AB: SEND TO SERVICE BUS to CLOSE Positions...
}
}
// For each Open Position, update the SL/TP etc and add it if its not in the Database...
foreach (cAlgo.API.Position AlgoP in Positions)
{
Model.Position LocalPosition = Business.Positions.GetByID(AlgoP.Id);
// find any changes to syn out to shadows...
//if (AlgoP.TakeProfit <> LocalPosition.TakeProfit | AlgoP.StopLoss <> LocalPosition.StopLoss )
//Update Postions...
Update(Account, AlgoP, "Opened");
}
}
private void SelectRecord()
{
if (dgDetails.Rows.Count >= 0 && iRowIndex >= 0)
{
if (RecordType == RECORD_TYPE.STUDENT)
{
oMStudent = new Model.Student();
oMStudent.UNIQUE_ID = dgDetails.Rows[iRowIndex].Cells[0].Value.ToString();
oMStudent.FIRST_NAME = dgDetails.Rows[iRowIndex].Cells[1].Value.ToString();
oMStudent.MIDDLE_NAME = dgDetails.Rows[iRowIndex].Cells[2].Value.ToString();
oMStudent.LAST_NAME = dgDetails.Rows[iRowIndex].Cells[3].Value.ToString();
oMStudent.DOB = dgDetails.Rows[iRowIndex].Cells[4].Value.ToString();
oMStudent.AGE = dgDetails.Rows[iRowIndex].Cells[5].Value.ToString();
oMStudent.COURSE = dgDetails.Rows[iRowIndex].Cells[6].Value.ToString();
oMStudent.SECTION = dgDetails.Rows[iRowIndex].Cells[7].Value.ToString();
oMStudent.CONTACT_NO = dgDetails.Rows[iRowIndex].Cells[8].Value.ToString();
oMStudent.ADDRESS = dgDetails.Rows[iRowIndex].Cells[9].Value.ToString();
}
else if (RecordType == RECORD_TYPE.PARTY)
{
oMParty = new Model.Party();
oMParty.ID = dgDetails.Rows[iRowIndex].Cells[0].Value.ToString();
oMParty.PARTY = dgDetails.Rows[iRowIndex].Cells[1].Value.ToString();
}
else if (RecordType == RECORD_TYPE.POSITION)
{
oMPosition = new Model.Position();
oMPosition.ID = dgDetails.Rows[iRowIndex].Cells[0].Value.ToString();
oMPosition.POSITION = dgDetails.Rows[iRowIndex].Cells[1].Value.ToString();
}
}
Close();
}
public PositionToAngles(Model.Position pos)
{
this.pos = pos;
}
/// <summary>
/// 更新某个库位.库位编号不变.
/// </summary>
/// <param name="posi">库位对象</param>
public bool updatePosition(Model.Position posi)
{
throw new System.NotImplementedException();
}
public static cAlgo.API.Position ToCAlgo(Model.Position Position)
{
return(null);
}
public static bool Save(Model.Position Position)
{
Hashtable Parameters = Data.Objects.ToHashTable(Position, "Save");
return(Data.SQLServer.Query().Execute(CommandType.StoredProcedure, StoredProcedure, Parameters));
}
protected void Button6_Click(object sender, EventArgs e)
{
switch (Button6.Text)
{
case "增加":
{
Warehouse.Tools.queryV qu = new Tools.queryV();
Warehouse.Tools.apartV ap = new Tools.apartV();
Warehouse.Tools.tiqushuzi quu = new Tools.tiqushuzi();
string L = qu.query("select length from PositionType where PositionTypeId='" + TextBox7.Text + "' ");
string W = qu.query("select width from PositionType where PositionTypeId='" + TextBox7.Text + "' ");
string H = qu.query("select height from PositionType where PositionTypeId='" + TextBox7.Text + "' ");
double a = double.Parse(qu.query("select M from Chest where chestNum='" + TextBox2.Text + "'"));
double b = double.Parse(qu.query("select Height from Chest where chestNum='" + TextBox2.Text + "'"));
double c = a * b - new Warehouse.Tools.positionSum().Sum(TextBox2.Text);
if ((quu.tiqu(L) * quu.tiqu(W) * (quu.tiqu(H)) < c))
{
try
{
DAL.Query nn = new DAL.Query();
int n = nn.query("position");
string nnn = "";
Model.Position add = new Model.Position();
add.Num = (n + 1).ToString();
add.PositionNum = TextBox1.Text;
add.ChestNum = TextBox2.Text;
add.RoomNum = TextBox3.Text;
add.PositiontypeId = TextBox7.Text;
add.M = (Convert.ToDouble(ap.apart(L)) * Convert.ToDouble(ap.apart(W))).ToString();
add.Height = (Convert.ToDouble(ap.apart(H))).ToString();
Warehouse.Tools.tiqushuzi tiqu = new Tools.tiqushuzi();
add.Rest = (tiqu.tiqu(add.M) * tiqu.tiqu(add.Height)).ToString();
for (int i = 0; i < ListBox3.Items.Count; i++)
{
if (nnn == "")
{
nnn += ListBox3.Items[i].Text;
}
else
{
nnn += "、" + ListBox3.Items[i].Text;
}
}
add.GoodsTypes = nnn;
add.Remark = TextBox6.Text;
add.CreateTime = DateTime.Now;
add.UpdateTime = DateTime.Now;
bool xx = new DAL.PositionDAO().addPosition(add);
//if (xx == true)
//{
// double kk = Convert.ToDouble(ap.apart(qu.query("select M from Chest where chestNum='" + TextBox2.Text + "' "))) - (Convert.ToDouble(ap.apart(L)) * Convert.ToDouble(ap.apart(W)));
// Warehouse.Tools.updateChestM up = new Tools.updateChestM();
// up.update(kk + "m²", TextBox2.Text);
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='管理库位.aspx'", true);
//}
}
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败！');", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败，最大体积为" + (a * b - new Warehouse.Tools.positionSum().Sum(TextBox1.Text)) + "！');", true);
}
}
break;
case "确定":
{
Button btn = sender as Button;
Model.Position update = new Model.Position();
update.PositionNum = TextBox1.Text;
update.ChestNum = TextBox2.Text;
update.RoomNum = TextBox3.Text;
update.PositiontypeId = TextBox7.Text;
string nnn = "";
for (int bbb = 0; bbb < ListBox3.Items.Count; bbb++)
{
if (nnn == "")
{
nnn += ListBox3.Items[bbb].Text;
}
else
{
nnn += "、" + ListBox3.Items[bbb].Text;
}
}
update.GoodsTypes = nnn;
update.Remark = TextBox6.Text;
update.UpdateTime = DateTime.Now;
bool xx = new DAL.PositionDAO().updatePosition(update);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
pg.Refresh("select num,positionNum,chestNum,roomNum,positionTypeId,goodsTypes,M,remark from Position", "positionNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
break;
}
}
public override void ExecuteCommand(EmsSession session, StringRequestInfo requestInfo)
{
session.LastLoginTime = System.DateTime.Now;
session.Logger.Info("##########################开始执行Command##########################");
try
{
session.LastLoginTime = System.DateTime.Now;
byte[] data = new byte[128];
string[] dataList = requestInfo.Body.Split('$');
string patrolerName = dataList[0];
string equip = dataList[1];
double x = Convert.ToDouble(dataList[2]);
double y = Convert.ToDouble(dataList[3]);
if ("OFFLINE" == session.Patroler.AccountState)
{
//不在线
//修改巡检员在线状态
session.Patroler.AccountState = "ONLINE";
new BLL.Patroler().setPatrolerAccountStateByName(session.Patroler);
session.Logger.Info("离线巡检人" + session.Patroler.UserName + "状态更新为ONLINE");
//查询是否有任务
session.Taskinfo = new BLL.TaskInfo().getTaskInfo(session.Patroler.UserName, "下发任务");
if (null == session.Taskinfo)
{
data = Encoding.UTF8.GetBytes("none" + "\r\n");
session.Send(data, 0, data.Length);
session.Logger.Info("离线巡检人" + session.Patroler.UserName + "没有获取到下发任务");
}
else
{
//发送任务工单号！
data = Encoding.UTF8.GetBytes(session.Taskinfo.DbId + "\r\n");
session.Send(data, 0, data.Length);
session.Logger.Info("离线巡检人" + session.Patroler.UserName + "获取到下发任务");
}
Model.LogInfo logInfoModel = new Model.LogInfo();
logInfoModel.Equipment = session.Equipment.MacId;
logInfoModel.Operate = "登录";
logInfoModel.Operate_time = DateTime.Now;
logInfoModel.Username = session.Patroler.UserName;
logInfoModel.Patroler_id = session.Patroler.DbId;
new BLL.LogInfo().insertLogInfo(logInfoModel);
session.Logger.Info("保存离线巡检人" + session.Patroler.UserName + "操作日志");
}
else
{
//在线人员定位信息
Model.Position position = new Model.Position();
position.Longitude = x;
position.Latitude = y;
position.Username = session.Patroler.UserName;
position.Patroler_id = session.Patroler.DbId;
position.ReceiveTime = DateTime.Now;
if (null != session.Taskinfo)
{
//插入带下发任务编号的人员定位信息
position.Task_id = session.Taskinfo.DbId;
new BLL.Position().insertPosition(position);
data = Encoding.UTF8.GetBytes(session.Taskinfo.DbId + "\r\n");
session.Send(data, 0, data.Length);
session.Logger.Info("保存在线巡检人" + session.Patroler.UserName + "任务位置信息！");
}
else
{//无下发任务编号 插入人员定位信息
new BLL.Position().insertPosition(position);
data = Encoding.UTF8.GetBytes("none" + "\r\n");
session.Send(data, 0, data.Length);
session.Logger.Info("保存在线巡检人" + session.Patroler.UserName + "位置信息！");
}
}
session.Logger.Info("##########################Command执行成功##########################");
session.Logger.Info("\n");
session.Logger.Info("\n");
session.Logger.Info("\n");
}
catch (Exception e)
{
session.Logger.Error("##########################Command执行错误##########################");
session.Logger.Error(e.ToString());
session.Logger.Error("\n");
session.Logger.Error("\n");
session.Logger.Error("\n");
}
}
public static bool Update(IAccount Account, cAlgo.API.Position Position, string Status)
{
Model.Position LocalPosition = GetByID(Position.Id);
if (LocalPosition == null)
{
LocalPosition = new Model.Position();
}
LocalPosition.ID = Position.Id;
LocalPosition.AccountID = Account.Number;
LocalPosition.Symbol = Position.SymbolCode;
LocalPosition.TradeType = Position.TradeType.ToString();
if (Position.Volume != 0)
{
LocalPosition.Volume = Position.Volume;
}
if (Position.Quantity != 0)
{
LocalPosition.Quantity = Position.Quantity;
}
if (Position.EntryPrice != 0)
{
LocalPosition.EntryPrice = (decimal)Position.EntryPrice;
}
if (Position.StopLoss != null)
{
LocalPosition.StopLoss = (decimal)Position.StopLoss;
}
if (Position.TakeProfit != null)
{
LocalPosition.TakeProfit = (decimal)Position.TakeProfit;
}
// LocalPosition.ClosedPrice = "";
if (Position.Swap != 0)
{
LocalPosition.Swap = (decimal)Position.Swap;
}
LocalPosition.Channel = "";
if (Position.Label != null)
{
LocalPosition.Label = Position.Label;
}
if (Position.Comment != null)
{
LocalPosition.Comment = Position.Comment;
}
LocalPosition.GrossProfit = (decimal)Position.GrossProfit;
LocalPosition.NetProfit = (decimal)Position.NetProfit;
LocalPosition.Pips = Position.Pips;
if (Status == "Opened")
{
LocalPosition.DateTimeCreatedUTC = DateTime.UtcNow;
}
LocalPosition.DateTimeLastModifiedUTC = DateTime.UtcNow;
LocalPosition.Status = Status;
return(Save(LocalPosition));
}
