/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmDelete_Click(object sender, EventArgs e)
{
try
{
Model_ColdstoragePDA coldpda = dataGridView1.SelectedRows[0].Tag as Model_ColdstoragePDA;
Model_ColdStorage coldstorage = new Model_ColdStorage();
coldstorage.Idk__BackingField = coldpda.StorageIdk__BackingField;
coldstorage.StorageNamek__BackingField = coldpda.StorageNamek__BackingField;
coldstorage.StorageTypek__BackingField = coldpda.StorageTypek__BackingField;
coldstorage.Driverk__BackingField = coldpda.Driverk__BackingField;
coldstorage.DriverTelk__BackingField = coldpda.DriverTelk__BackingField;
coldstorage.CreateAtk__BackingField = coldpda.StorageCreateAtk__BackingField;
coldstorage.Remarkk__BackingField = coldpda.Remarkk__BackingField;
coldstorage.Activedk__BackingField = Enum_Active.Disable;
if (MessageBox.Show("是否确定删除？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ResultModelOfModel_ColdStoraged4FqxSXX actiove = cs.EditColdstorage(coldstorage, Convert.ToInt32(coldpda.isDefaultk__BackingField), true, coldpda.StorageDeviceIdk__BackingField, true, coldpda.PDAIdk__BackingField, true, true, true);
if (actiove.Code != 0)
{
MessageBox.Show(actiove.Message);
}
else
{
MessageBox.Show("操作成功，冷库已停用");
WarehouseLoad();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (cmbPDA.Text.Trim() == string.Empty)
{
MessageBox.Show("PDA设备不能为空");
return;
}
Model_ColdStorage mcs = new Model_ColdStorage();
mcs.Idk__BackingField = mcp.StorageIdk__BackingField;
mcs.StorageNamek__BackingField = mcp.StorageNamek__BackingField;
mcs.StorageTypek__BackingField = mcp.StorageTypek__BackingField;
mcs.Driverk__BackingField = mcp.Driverk__BackingField;
mcs.DriverTelk__BackingField = mcp.DriverTelk__BackingField;
mcs.Remarkk__BackingField = mcp.Remarkk__BackingField;
// mcs.CreateAtk__BackingField = mcp.CreateAtk__BackingField;
mcs.CreateAtk__BackingField = mcp.StorageCreateAtk__BackingField;
int PDAid = Convert.ToInt32(cmbPDA.SelectedValue);
int DefaultDevice;
if (checDefault.Checked == true)
{
//if (MessageBox.Show("是否默认该设备?", "Prompt", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
//{
DefaultDevice = (int)Enum_IsDefault.Eefault;
Model_Storage_Device sto = new Model_Storage_Device();
sto.deviceIdk__BackingField = PDAid;
sto.isDefaultk__BackingField = DefaultDevice;
ResultModelOfModel_Storage_Deviced4FqxSXX st = cs.GetDefaultDevice(sto);
if (st.Code != 0)
{
MessageBox.Show("操作失败");
}
//}else
// DefaultDevice = (int)Enum_IsDefault.NotDefault;
}
else
{
DefaultDevice = (int)Enum_IsDefault.NotDefault;
}
ResultModelOfModel_ColdStoraged4FqxSXX coldstoreage = cs.EditColdstorage(mcs, DefaultDevice, true, mcp.StorageDeviceIdk__BackingField, true, PDAid, true, true, true);
if (coldstoreage.Code != 0)
{
MessageBox.Show(coldstoreage.Message);
}
else
{
MessageBox.Show("操作成功");
_ParentWare.waLoad();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static Model_ColdStorage GetStorName(Model_ColdStorage coldstorageInfo)
{
//判断冷库/车载车牌的名称是否存在
string sql = "select * from coldstorage where storageName=?storageName ";
MySqlParameter[] p = new MySqlParameter[1];
p[0] = new MySqlParameter("storageName", coldstorageInfo.StorageName);
Model_ColdStorage coldstoragename = _SqlHelp.ExecuteObject <Model_ColdStorage>(sql, p);
return(coldstoragename);
}
/// <summary>
/// 编辑冷藏载体信息
/// storageID不为0时表示编辑或删除
/// storageID为0时表示添加
/// </summary>
/// <param name="coldstorageInfo">冷藏载体信息</param>
/// <param name="pdaId">绑定的PDAId</param>
/// <param name="isDeleteStorage">True:storageID不为0时执行删除操作;False:storageID为0时不删除执行添加操作</param>
/// <param name="defaultDevice">0不是默认，1是默认</param>
/// <returns></returns>
public ResultModel <Model_ColdStorage> EditColdstorage(Model_ColdStorage coldstorageInfo, int defaultDevice, int storageDeviceId = 0, int pdaId = 0, bool isDeleteStorage = false)
{
ResultModel <Model_ColdStorage> result = new ResultModel <Model_ColdStorage>();
try
{
result.Data = ColdstorageServer.EditColdstorages(coldstorageInfo, defaultDevice, storageDeviceId, pdaId, isDeleteStorage);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtWarehouseName.Text.Trim() == string.Empty)
{
MessageBox.Show("仓库名称不能为空");
return;
}
if (Encoding.Default.GetBytes(txtWarehouseName.Text.Trim()).Length > 100)
{
MessageBox.Show("仓库名称不能超过100");
return;
}
if (cmbPDA.Text.Trim() == string.Empty)
{
MessageBox.Show("PDA设备不能为空");
return;
}
if (cmbStorageType.Text.Trim() == string.Empty)
{
MessageBox.Show("存储类型不能为空");
return;
}
Model_ColdStorage mcs = new Model_ColdStorage();
mcs.StorageNamek__BackingField = txtWarehouseName.Text.Trim();
if (cmbStorageType.Text == "冷库")
{
mcs.StorageTypek__BackingField = Enum_StorageType.ColdStorage;
}
else
{
mcs.StorageTypek__BackingField = Enum_StorageType.CarStorage;
}
mcs.CreateAtk__BackingField = DateTime.Now;
if (rdbEnabled.Checked == true)
{
mcs.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
mcs.Activedk__BackingField = Enum_Active.Disable;
}
int PDAid = Convert.ToInt32(cmbPDA.SelectedValue);
int DefaultDevice;
if (checDefault.Checked == true)
{
DefaultDevice = (int)Enum_IsDefault.Eefault;
Model_Storage_Device sto = new Model_Storage_Device();
sto.deviceIdk__BackingField = PDAid;
sto.isDefaultk__BackingField = DefaultDevice;
ResultModelOfModel_Storage_Deviced4FqxSXX st = cs.GetDefaultDevice(sto);
if (st.Code != 0)
{
MessageBox.Show("操作失败");
}
}
else
{
DefaultDevice = (int)Enum_IsDefault.NotDefault;
}
ResultModelOfModel_ColdStoraged4FqxSXX coldstoreage = cs.EditColdstorage(mcs, DefaultDevice, true, 0, true, PDAid, true, false, true);
if (coldstoreage.Code != 0)
{
MessageBox.Show(coldstoreage.Message);
}
else
{
MessageBox.Show("操作成功");
getClear();
WarehouseLoad();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtLicensePlate.Text.Trim() == string.Empty)
{
MessageBox.Show("车载系统车牌不能为空");
return;
}
if (Encoding.Default.GetBytes(txtLicensePlate.Text.Trim()).Length > 100)
{
MessageBox.Show("车载系统车牌不能超过100");
return;
}
if (Encoding.Default.GetBytes(txtPilot.Text.Trim()).Length > 50)
{
MessageBox.Show("车载驾驶员不能超过50");
return;
}
if (cmbPDA.Text == string.Empty)
{
MessageBox.Show("PDA设备不能为空");
return;
}
if (Encoding.Default.GetBytes(txtTelephone.Text.Trim()).Length > 50)
{
MessageBox.Show("驾驶员电话不能超过50");
return;
}
if (txtTelephone.Text.Trim() != string.Empty)
{
if (!IsTelephone(txtTelephone.Text.Trim()))
{
MessageBox.Show("你输入不是手机/电话号码！");
return;
}
}
if (cmbStorageType.Text == string.Empty)
{
MessageBox.Show("存储类型不能为空");
return;
}
if (Encoding.Default.GetBytes(txtRemark.Text.Trim()).Length > 200)
{
MessageBox.Show("备注不能超过200");
return;
}
Model_ColdStorage cold = new Model_ColdStorage();
if (cmbStorageType.Text == "冷库")
{
cold.StorageTypek__BackingField = Enum_StorageType.ColdStorage;
}
else
{
cold.StorageTypek__BackingField = Enum_StorageType.CarStorage;
}
if (IsVehicleNumber(txtLicensePlate.Text.Trim()))
{
cold.StorageNamek__BackingField = txtLicensePlate.Text.Trim();
}
else
{
MessageBox.Show("你输入的不是车牌号");
return;
}
cold.Driverk__BackingField = txtPilot.Text.Trim();
cold.DriverTelk__BackingField = txtTelephone.Text.Trim();
cold.Remarkk__BackingField = txtRemark.Text.Trim();
cold.CreateAtk__BackingField = DateTime.Now;
if (rdbEnabled.Checked == true)
{
cold.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
cold.Activedk__BackingField = Enum_Active.Disable;
}
int PDAid = Convert.ToInt32(cmbPDA.SelectedValue);
int DefaultDevice;
if (checDefault.Checked == true)
{
DefaultDevice = (int)Enum_IsDefault.Eefault;
Model_Storage_Device sto = new Model_Storage_Device();
sto.deviceIdk__BackingField = PDAid;
sto.isDefaultk__BackingField = DefaultDevice;
ResultModelOfModel_Storage_Deviced4FqxSXX st = cs.GetDefaultDevice(sto);
if (st.Code != 0)
{
MessageBox.Show("操作失败");
}
}
else
{
DefaultDevice = (int)Enum_IsDefault.NotDefault;
}
ResultModelOfModel_ColdStoraged4FqxSXX coldstorage = cs.EditColdstorage(cold, DefaultDevice, true, 0, true, PDAid, true, false, true);
if (coldstorage.Code != 0)
{
MessageBox.Show(coldstorage.Message);
}
else
{
MessageBox.Show("操作成功");
qingkong();
MountedListLoad();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 新增/更新
/// </summary>
/// <param name="coldstorageInfo"></param>
/// <param name="pdaId"></param>
/// <param name="isDeleteStorage">True:storageID不为0时执行删除操作;False:storageID为0时不删除执行添加操作</param>
/// <param name="defaultDevice">0不是默认，1是默认</param>
/// <returns></returns>
public static Model_ColdStorage EditColdstorages(Model_ColdStorage coldstorageInfo, int defaultDevice, int storageDeviceId, int pdaId, bool isDeleteStorage)
{
string sql = "";
//判断修改的时候冷库/车载车牌的名称是否变更过
if (coldstorageInfo.Id != 0 && isDeleteStorage == true)
{
sql = "select * from coldstorage where id=?id ;";
MySqlParameter[] coldid = new MySqlParameter[1];
coldid[0] = new MySqlParameter("id", coldstorageInfo.Id);
Model_ColdStorage co = _SqlHelp.ExecuteObject <Model_ColdStorage>(sql, coldid);
if (co.StorageName != coldstorageInfo.StorageName)
{
Model_ColdStorage SN = GetStorName(coldstorageInfo);
if (SN != null)
{
throw new Exception("仓库名称/车载系统车牌已存在");
}
}
}
if (coldstorageInfo.Id == 0 && isDeleteStorage == false)
{
Model_ColdStorage SN = GetStorName(coldstorageInfo);
if (SN != null)
{
throw new Exception("仓库名称/车载系统车牌已存在");
}
}
if (coldstorageInfo.Id == 0 && isDeleteStorage == false)
{
sql = "insert into coldstorage(storageName,storagetype,driver,driverTel,remark,createAt,actived) " +
"values(?storageName,?storagetype,?driver,?driverTel,?remark,?createAt,?actived);select LAST_INSERT_ID(); ";
}
if (coldstorageInfo.Id != 0 && isDeleteStorage == true)
{
sql = "update coldstorage set storageName=?storageName,storageType=?storageType,driver=?driver,driverTel=?driverTel,remark=?remark,actived=?actived " +
"where id =?id ;";
}
MySqlParameter[] para = new MySqlParameter[8];
para[0] = new MySqlParameter("storageName", coldstorageInfo.StorageName);
para[1] = new MySqlParameter("storagetype", coldstorageInfo.StorageType);
para[2] = new MySqlParameter("driver", coldstorageInfo.Driver);
para[3] = new MySqlParameter("driverTel", coldstorageInfo.DriverTel);
para[4] = new MySqlParameter("remark", coldstorageInfo.Remark);
para[5] = new MySqlParameter("createAt", coldstorageInfo.CreateAt);
para[6] = new MySqlParameter("actived", coldstorageInfo.Actived);
para[7] = new MySqlParameter("id", coldstorageInfo.Id);
//返回添加数据的id
ulong result = 0;
if (coldstorageInfo.Id == 0)
{
result = (ulong)_SqlHelp.ExecuteScalar(sql, para);
if (result <= 0)
{
throw new Exception("操作失败");
}
//线程 动态创建数据表
Thread t = new Thread(new ParameterizedThreadStart(ColdstorageServer.GetThread));
t.Start(result);
}
else
{
int resu = _SqlHelp.ExecuteNonQuery(sql, para);
if (resu != 1)
{
throw new Exception("操作失败");
}
else
{
result = (ulong)coldstorageInfo.Id;
}
}
if (coldstorageInfo.Id == 0 && isDeleteStorage == false)
{
sql = "insert into storage_device(storageId,deviceId,isDefault) values(?storageId,?deviceId,?isDefault)";
}
else
{
sql = "update storage_device set storageId=?storageId,deviceId=?deviceId,isDefault=?isDefault " +
"where id =?id ; ";
}
MySqlParameter[] pa = new MySqlParameter[4];
pa[0] = new MySqlParameter("storageId", result);
pa[1] = new MySqlParameter("deviceId", pdaId);
pa[2] = new MySqlParameter("isDefault", defaultDevice);
if (coldstorageInfo.Id != 0 && isDeleteStorage == true)
{
//获取冷库，车载与PDA设备关联的id
foreach (Model_Storage_Device item in GetStoDevi(storageDeviceId))
{
pa[3] = new MySqlParameter("id", item.id);
}
}
else
{
pa[3] = new MySqlParameter("id", null);
}
int stodev = 0;
stodev = _SqlHelp.ExecuteNonQuery(sql, pa);
if (stodev != 1)
{
throw new Exception("操作失败");
}
return(coldstorageInfo);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtLicensePlate.Text.Trim() == string.Empty)
{
MessageBox.Show("车载系统车牌不能为空");
return;
}
if (Encoding.Default.GetBytes(txtLicensePlate.Text.Trim()).Length > 100)
{
MessageBox.Show("车载系统车牌不能超过100");
return;
}
if (cmbPDA.Text.Trim() == string.Empty)
{
MessageBox.Show("PDA设备不能为空");
return;
}
if (cmbStorageType.Text.Trim() == string.Empty)
{
MessageBox.Show("存储类型不能为空");
return;
}
if (Encoding.Default.GetBytes(txtPilot.Text.Trim()).Length > 50)
{
MessageBox.Show("车载驾驶员不能超过50");
return;
}
if (Encoding.Default.GetBytes(txtTelephone.Text.Trim()).Length > 50)
{
MessageBox.Show("驾驶员电话不能超过50");
return;
}
if (txtTelephone.Text.Trim() != string.Empty)
{
if (!IsTelephone(txtTelephone.Text.Trim()))
{
MessageBox.Show("你输入不是手机/电话号码！");
return;
}
}
if (Encoding.Default.GetBytes(txtRemark.Text.Trim()).Length > 200)
{
MessageBox.Show("备注不能超过200");
return;
}
Model_ColdStorage coldpdalist = new Model_ColdStorage();
coldpdalist.Idk__BackingField = coldpda.StorageIdk__BackingField;
if (IsVehicleNumber(txtLicensePlate.Text.Trim()))
{
coldpdalist.StorageNamek__BackingField = txtLicensePlate.Text;
}
else
{
MessageBox.Show("你输入的不是车牌号");
return;
}
if (cmbStorageType.Text == "冷库")
{
coldpdalist.StorageTypek__BackingField = Enum_StorageType.ColdStorage;
}
else
{
coldpdalist.StorageTypek__BackingField = Enum_StorageType.CarStorage;
}
coldpdalist.Driverk__BackingField = txtPilot.Text;
coldpdalist.DriverTelk__BackingField = txtTelephone.Text;
coldpdalist.Remarkk__BackingField = txtRemark.Text;
if (rdbEnabled.Checked == true)
{
coldpdalist.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
coldpdalist.Activedk__BackingField = Enum_Active.Disable;
}
int pdaid = Convert.ToInt32(cmbPDA.SelectedValue);
int isDefault;
if (checDefault.Checked == true)
{
//if (MessageBox.Show("是否默认该设备?", "Prompt", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
//{
isDefault = (int)Enum_IsDefault.Eefault;
Model_Storage_Device sto = new Model_Storage_Device();
sto.deviceIdk__BackingField = pdaid;
sto.isDefaultk__BackingField = isDefault;
ResultModelOfModel_Storage_Deviced4FqxSXX st = cs.GetDefaultDevice(sto);
if (st.Code != 0)
{
MessageBox.Show("操作失败");
}
//}
//else
// isDefault = (int)Enum_IsDefault.NotDefault;
}
else
{
isDefault = (int)Enum_IsDefault.NotDefault;
}
ResultModelOfModel_ColdStoraged4FqxSXX edit = cs.EditColdstorage(coldpdalist, isDefault, true, coldpda.StorageDeviceIdk__BackingField, true, pdaid, true, true, true);
if (edit.Code != 0)
{
MessageBox.Show(edit.Message);
}
else
{
MessageBox.Show("操作成功");
_Parentmounted.ColdPDALoad();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
