/// <summary>
/// 应用当前选中的LED设置
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLEDApplication_Click(object sender, EventArgs e)
{
try
{
CommonalityEntity.IsCancellation = false;
isUpdate = -1;
if (ChkPositionLEDState())
{
DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置，是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.OK)
{
//修改条件
Expression <Func <PositionLED, bool> > funs = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_Position_ID"].Value.ToString());
//需要修改的内容
Action <PositionLED> actions = p =>
{
p.PositionLED_State = "暂停";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(funs, actions);
//应用当前选中的设置
//条件
int id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString());
Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == id;
//需要的内容
Action <PositionLED> action = p =>
{
p.PositionLED_State = "启动";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(fun, action);
CommonalityEntity.WriteLogData("修改", "启动编号为：" + id + "的LED显示信息", CommonalityEntity.USERNAME);//操作日志
}
else
{
return;
}
}
else
{
//应用当前选中的设置
//条件
int id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString());
Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == id;
//需要的内容
Action <PositionLED> action = p =>
{
p.PositionLED_State = "启动";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(fun, action);
CommonalityEntity.WriteLogData("修改", "启动编号为：" + id + "的LED显示信息", CommonalityEntity.USERNAME);//操作日志
}
}
catch
{
CommonalityEntity.WriteTextLog("LEDSerForm btnLEDApplication_Click()");
}
finally
{
GetGriddataviewLoad("");//加载
}
}
/// <summary>
/// 保存用户操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
isUpdate = 1;
if (!ChkContent())
{
return;
}
//判断是否修改
//添加数据到数据库
PositionLED pLED = new PositionLED();
#region 获取页面的数据
pLED.PositionLED_Position_ID = int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString());
if (cboleixing.Text == "排队信息")
{
pLED.PositionLED_Type = 1;
}
else if (cboleixing.Text == "欢迎语")
{
pLED.PositionLED_Type = 2;
}
pLED.PositionLED_ScreenHeight = int.Parse(txtPositionLED_ScreenHeight.Text.Trim());
pLED.PositionLED_ScreenWeight = int.Parse(txtPositionLED_ScreenWeight.Text.Trim());
pLED.PositionLED_X = int.Parse(txtPositionLED_X.Text.Trim());
pLED.PositionLED_Y = int.Parse(txtPositionLED_Y.Text.Trim());
pLED.PositionLED_Count = int.Parse(cbotiaoshu.Text.Trim());
pLED.PositionLED_Remark = txtPositionLED_Remark.Text.Trim();
//pLED.PositionLED_PassageState = chkboxLEDPassState.Text.ToString();
//保存选择的字体设置项目
pLED.PositionLED_Font = fontdlgFont.Font.Name.ToString();
pLED.PositionLED_FontSize = fontdlgFont.Font.Size.ToString();
pLED.PositionLED_Color = colordlgFont.Color.ToString();
if (cboleixing.Text == "欢迎语")
{
pLED.PositionLED_Content = "";
pLED.PositionLED_Operate = CommonalityEntity.USERNAME;
pLED.PositionLED_Time = CommonalityEntity.GetServersTime();
#endregion
pLED.PositionLED_State = chkboxLEDState.Text.Trim();
if (chkboxLEDState.Text.Trim() == "启动")
{
if (ChkPositionLEDState())
{
DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置，是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.OK)
{
//修改条件
Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString());
//需要修改的内容
Action <PositionLED> action = p =>
{
p.PositionLED_State = "暂停";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(fun, action);
PositionLEDDAL.InsertPositionLED(pLED);
}
else
{
pLED.PositionLED_State = "暂停";
PositionLEDDAL.InsertPositionLED(pLED);
}
}
else
{
PositionLEDDAL.InsertPositionLED(pLED);
}
}
else
{
PositionLEDDAL.InsertPositionLED(pLED);
}
DataTable dt = dt = LinQBaseDao.Query("select PositionLED_ID,PositionLED_State from PositionLED order by PositionLED_ID desc").Tables[0];
string positionled_id = dt.Rows[0][0].ToString();
string state = dt.Rows[0][1].ToString();
if (state == "启动")
{
CommonalityEntity.WriteLogData("新增", "新增并启动编号为：" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志
}
else
{
CommonalityEntity.WriteLogData("新增", "新增编号为：" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
else if (cboleixing.Text == "排队信息")
{
string serialnumber = "";
string carType = "";
string carNumber = "";
if (chkCarNumber.Checked)
{
carNumber = chkCarNumber.Text.Trim() + ",";
}
if (chkCarType.Checked)
{
carType = chkCarType.Text.Trim() + ",";
}
if (chkSerialnumber.Checked)
{
serialnumber = "distinct(" + chkSerialnumber.Text.Trim() + "),";
}
string chklists = "";
if (list.Count() > 1)
{
foreach (var item in list)
{
chklists += (item.ToString() + ",");
}
list.Clear();
}
string listsql = serialnumber + carNumber + carType + chklists;
listsql = listsql.TrimEnd(',');
//限定选择的显示内容只能为3个
string[] split = listsql.Split(',');
int num = 0;
for (int i = 0; i < split.Length; i++)
{
num++;
}
if (num > 3)
{
MessageBox.Show("排队信息显示的项目最多选择3项", "错误提示");
return;
}
else
{
string sql = "Select " + listsql + " from View_LEDShow_zj";
pLED.PositionLED_Content = sql;
pLED.PositionLED_Operate = CommonalityEntity.USERNAME;
pLED.PositionLED_Time = CommonalityEntity.GetServersTime();
pLED.PositionLED_State = chkboxLEDState.Text.Trim();
if (chkboxLEDState.Text.Trim() == "启动")
{
if (ChkPositionLEDState())
{
DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置，是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.OK)
{
//修改条件
Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString());
//需要修改的内容
Action <PositionLED> action = p =>
{
p.PositionLED_State = "暂停";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(fun, action);
PositionLEDDAL.InsertPositionLED(pLED);
}
else
{
pLED.PositionLED_State = "暂停";
PositionLEDDAL.InsertPositionLED(pLED);
}
}
else
{
PositionLEDDAL.InsertPositionLED(pLED);
}
}
else
{
PositionLEDDAL.InsertPositionLED(pLED);
}
DataTable dt = dt = LinQBaseDao.Query("select PositionLED_ID,PositionLED_State from PositionLED order by PositionLED_ID desc").Tables[0];
string positionled_id = dt.Rows[0][0].ToString();
string state = dt.Rows[0][1].ToString();
if (state == "启动")
{
CommonalityEntity.WriteLogData("新增", "新增并启动编号为：" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志
}
else
{
CommonalityEntity.WriteLogData("新增", "新增编号为：" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志
}
}
}
}
catch
{
//记录错误日志
CommonalityEntity.WriteTextLog("LEDSetForm btnAdd_Click()");
}
finally
{
GetGriddataviewLoad("");//绑定列表
Empty();
}
}
/// <summary>
/// 选中列表中的项进行修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (this.lvwUserList.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择要修改的项！");
return;
}
else if (!ChkContent())
{
return;
}
//修改条件
Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString());
string positionLED_State = chkboxLEDState.Text.Trim();
if (chkboxLEDState.Text.Trim() == "启动")
{
if (ChkPositionLEDState())
{
DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置，是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlgResult == DialogResult.OK)
{
//修改条件
Expression <Func <PositionLED, bool> > funs = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_Position_ID"].Value.ToString());
//需要修改的内容
Action <PositionLED> actions = p =>
{
p.PositionLED_State = "暂停";
};
//执行更新
PositionLEDDAL.UpdatePositionLED(funs, actions);
}
else
{
return;
}
}
}
string id = "";
string strfront = "";
string strcontent = "";
//需要修改的内容
Action <PositionLED> action = pLED =>
{
strfront = pLED.PositionLED_Position_ID + "," + pLED.PositionLED_ScreenHeight + "," + pLED.PositionLED_ScreenWeight + "," + pLED.PositionLED_X + "," + pLED.PositionLED_Y + "," + pLED.PositionLED_IntervalX + "," + pLED.PositionLED_IntervalY + "," + pLED.PositionLED_Count + "," + pLED.PositionLED_Remark + "," + pLED.PositionLED_State + "," + pLED.PositionLED_Font + "," + pLED.PositionLED_FontSize + "," + pLED.PositionLED_Color + "," + pLED.PositionLED_Content;
pLED.PositionLED_Position_ID = int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString());
if (cboleixing.Text == "排队信息")
{
pLED.PositionLED_Type = 1;
}
else if (cboleixing.Text == "欢迎语")
{
pLED.PositionLED_Type = 2;
}
pLED.PositionLED_ScreenHeight = int.Parse(txtPositionLED_ScreenHeight.Text.Trim());
pLED.PositionLED_ScreenWeight = int.Parse(txtPositionLED_ScreenWeight.Text.Trim());
pLED.PositionLED_X = int.Parse(txtPositionLED_X.Text.Trim());
pLED.PositionLED_Y = int.Parse(txtPositionLED_Y.Text.Trim());
pLED.PositionLED_Count = int.Parse(cbotiaoshu.Text.Trim());
pLED.PositionLED_Remark = txtPositionLED_Remark.Text.Trim();
//pLED.PositionLED_PassageState = chkboxLEDPassState.Text.ToString();
pLED.PositionLED_State = chkboxLEDState.Text.Trim();
pLED.PositionLED_Font = fontdlgFont.Font.Name.ToString();
pLED.PositionLED_FontSize = fontdlgFont.Font.Size.ToString();
pLED.PositionLED_Color = colordlgFont.Color.ToString();
string userialnumber = "";
string ucarType = "";
string ucarNumber = "";
if (chkCarNumber.Checked)
{
ucarNumber = chkCarNumber.Text.Trim() + ",";
}
if (chkCarType.Checked)
{
ucarType = chkCarType.Text.Trim() + ",";
}
if (chkSerialnumber.Checked)
{
userialnumber = "distinct(" + chkSerialnumber.Text.Trim() + "),";
}
string uchklists = "";
if (list.Count() > 0)
{
foreach (var item in list)
{
uchklists += (item.ToString() + ",");
}
list.Clear();
}
string ulistsql = userialnumber + ucarNumber + ucarType + uchklists;
string sql = "Select " + ulistsql.TrimEnd(',') + " from View_LEDShow_zj";
pLED.PositionLED_Content = sql;
strcontent = pLED.PositionLED_Position_ID + "," + pLED.PositionLED_ScreenHeight + "," + pLED.PositionLED_ScreenWeight + "," + pLED.PositionLED_X + "," + pLED.PositionLED_Y + "," + pLED.PositionLED_IntervalX + "," + pLED.PositionLED_IntervalY + "," + pLED.PositionLED_Count + "," + pLED.PositionLED_Remark + "," + pLED.PositionLED_State + "," + pLED.PositionLED_Font + "," + pLED.PositionLED_FontSize + "," + pLED.PositionLED_Color + "," + pLED.PositionLED_Content;
id = pLED.PositionLED_ID.ToString();
};
//执行更新
PositionLEDDAL.UpdatePositionLED(fun, action);
CommonalityEntity.WriteLogData("修改", "更新编号为：" + id + "的LED显示信息,修改前：" + strfront + "；修改后：" + strcontent, CommonalityEntity.USERNAME);
btnUpdate.Enabled = false;
btnAdd.Enabled = true;
}
catch
{
//记录错误日志
CommonalityEntity.WriteTextLog("LEDSetForm btnAdd_Click()");
}
finally
{
GetGriddataviewLoad("");//绑定列表
Empty();
}
}
