public static List <View_FVN_Driveway_Position> GetSQLList(string sql)
{
//DataSet dataset = LinQBaseDao.Query(sql);
//List<View_FVN_Driveway_Position> list = new List<View_FVN_Driveway_Position>();
//if (dataset != null)
//{
// if (dataset.Tables.Count > 0)
// {
// foreach (DataRow dr in dataset.Tables[0].Rows)
// {
// View_FVN_Driveway_Position dcl = new View_FVN_Driveway_Position();
// dcl.Driveway_Add = dr["Driveway_Add"].ToString();
// dcl.Driveway_Address = dr["Driveway_Address"].ToString();
// dcl.Driveway_CreatTime =Common.Converter.ToDateTime(dr["Driveway_CreatTime"].ToString());
// dcl.Driveway_ID = Common.Converter.ToInt(dr["Driveway_ID"].ToString());
// dcl.Driveway_Name = dr["Driveway_Name"].ToString();
// dcl.Driveway_Position_ID = Common.Converter.ToInt( dr["Driveway_Position_ID"].ToString());
// dcl.Driveway_ReadCardPort = dr["Driveway_ReadCardPort"].ToString();
// dcl.Driveway_Remark =dr["Driveway_Remark"].ToString();
// dcl.Driveway_Remark_Driveway_ID = Common.Converter.ToInt( dr["Driveway_Remark_Driveway_ID"].ToString());
// dcl.Driveway_State = dr["Driveway_State"].ToString();
// dcl.Driveway_Type = dr["Driveway_Type"].ToString();
// dcl.Driveway_UserId = Common.Converter.ToInt(dr["Driveway_UserId"].ToString());
// dcl.Driveway_Value = dr["Driveway_Value"].ToString();
// dcl.Driveway_WarrantyState = dr["Driveway_WarrantyState"].ToString();
// dcl.FVN_Driveway_ID = Common.Converter.ToInt(dr["FVN_Driveway_ID"].ToString());
// dcl.FVN_ID = Common.Converter.ToInt(dr["FVN_ID"].ToString());
// dcl.FVN_Name = dr["FVN_Name"].ToString();
// dcl.FVN_Remark = dr["FVN_Remark"].ToString();
// dcl.FVN_State = dr["FVN_State"].ToString();
// dcl.FVN_Type = dr["FVN_Type"].ToString();
// dcl.FVN_Value = Common.Converter.ToInt(dr["FVN_Value"].ToString());
// dcl.Position_Add = dr["Position_Add"].ToString();
// dcl.Position_CameraValue = dr["Position_CameraValue"].ToString();
// dcl.Position_CreatTime = Common.Converter.ToDateTime(dr["Position_CreatTime"].ToString());
// dcl.Position_ID = Common.Converter.ToInt(dr["Position_ID"].ToString());
// dcl.Position_Name = dr["Position_Name"].ToString();
// dcl.Position_Phone = dr["Position_Phone"].ToString();
// dcl.Position_Remark = dr["Position_Remark"].ToString();
// dcl.Position_State = dr["Position_State"].ToString();
// dcl.Position_UserId = Common.Converter.ToInt( dr["Position_UserId"].ToString());
// dcl.Position_Value = dr["Position_Value"].ToString();
// }
// }
//}
//return list;
IEnumerable <View_FVN_Driveway_Position> list = LinQBaseDao.GetItemsForListing <View_FVN_Driveway_Position>(sql);
return(list.ToList());
}
/// <summary>
/// 根据传入的sql在eh_FVN中查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static IEnumerable <Camera> GetViewCamera(string sql)
{
return(LinQBaseDao.GetItemsForListing <Camera>(sql));
}
private async Task GetWeightDataThree()
{
await Task.Factory.StartNew(() =>
{
if (this.InvokeRequired)
{
this.Invoke(new AsynUpdateUI(delegate()
{
string sql = "select * from dbo.ImageRecord where ImageRecord_QCRecord_ID in(select QCRecord_ID from QCRecord where QCRecord_QCInfo_ID=" + qcinfoid + ")";
List <ImageRecord> list = new List <ImageRecord>();
list = LinQBaseDao.GetItemsForListing <ImageRecord>(sql).ToList();
if (list.Count >= 1)
{
//得到图片的路径
string path = Common.SaveFiel;
////获取文件夹下的图片信息
//List<string> strList = ImageFile.GetImage(path, false);
//将得到的图片信息绑定到页面
int listcount = list.Count();
double wight = 0, height = 0;
int sss = 0, mmm = 0;
double doucount = Math.Sqrt(listcount);
if (Convert.ToInt32(doucount) == doucount)
{
wight = (480 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
sss = Convert.ToInt32(doucount);
}
else
{
if (doucount - (int)(doucount) == 0)
{
sss = Convert.ToInt32(doucount);
}
else
{
sss = (int)(doucount + 1);
}
wight = (480 - 10 * (sss + 2)) / Convert.ToInt32(sss);
}
height = (430 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
mmm = Math.Abs((int)(listcount / sss) - ((double)listcount / (double)sss)) == 0 ? (listcount / sss) : (int)(((double)listcount / (double)sss)) + 1;
int x = 0;
int y = 0;
gbShowImage.Controls.Clear();
int k = 0;
for (int i = 0; i < mmm; i++)
{
y = Convert.ToInt32(10 * (i + 1) + i *height) + 10;
for (int m = 0; m < sss; m++)
{
if (k >= listcount)
{
return;
}
x = Convert.ToInt32(10 * (m + 1) + m *wight) + 5;
PictureBox pb = new PictureBox();
pb.Location = new Point(x, y);
pb.Width = Convert.ToInt32(wight);
pb.Height = Convert.ToInt32(height);
pb.SizeMode = pictureBox1.SizeMode;
pb.MouseHover += new System.EventHandler(this.pbInImageOne_MouseHover);
pb.MouseLeave += new System.EventHandler(this.pbInImageOne_MouseLeave);
pb.Name = "pictureBox" + list[k].ImageRecord_QCRecord_ID.ToString();
pb.Tag = path + list[k].ImageRecord_ImageName;
pb.ImageLocation = path + list[k].ImageRecord_ImageName;
this.gbShowImage.Controls.Add(pb);
k++;
}
}
}
}));
}
});
}
/// <summary>
/// 根据IC卡或小票取出车辆信息
/// </summary>
private void LoadData()
{
strsql();
if (sql == "")
{
MessageBox.Show("没有该IC卡(小票)号的信息！");
return;
}
DataTable ds = LinQBaseDao.Query(sql).Tables[0];
if (ds.Rows.Count < 1)
{
Empty();
return;
}
txtInWeight.Text = "";
txtOutWeight.Text = "";
txtCartype_Name.Text = ds.Rows[0]["CarType_Name"].ToString();
txtCartype_Name.Tag = ds.Rows[0]["CarType_ID"].ToString();
txtCarregistration_Customer.Text = ds.Rows[0]["CustomerInfo_Name"].ToString();
txtCarregistration_Name.Text = ds.Rows[0]["StaffInfo_Name"].ToString();
txtCarregistration_Name.Tag = ds.Rows[0]["StaffInfo_ID"].ToString();
txtCarregistration_Carnumber.Text = ds.Rows[0]["CarInfo_Name"].ToString();
txtCarregistration_Carnumber.Tag = ds.Rows[0]["CarInfo_ID"].ToString();
CommonalityEntity.CarInfo_ID = ds.Rows[0]["CarInfo_ID"].ToString();
// txtCarregistration_License.Text = ds.Rows[0]["StaffInfo_License"].ToString();
txtCarregistration_Phone.Text = ds.Rows[0]["StaffInfo_Phone"].ToString();
txtCarregistration_IdentityCard.Text = ds.Rows[0]["StaffInfo_Identity"].ToString();
txtCarregistration_Carriage.Text = ds.Rows[0]["CarInfo_Carriage"].ToString();
txtCarregistration_Weight.Text = ds.Rows[0]["CarInfo_Weight"].ToString();
txtCarregistration_Height.Text = ds.Rows[0]["CarInfo_Height"].ToString();
if (Convert.ToBoolean(ds.Rows[0]["CarInfo_Bail"].ToString()) == true)
{
ckbCarInfo_Bail.Checked = true;
}
else
{
ckbCarInfo_Bail.Checked = false;
}
txtOperateTime.Text = ds.Rows[0]["CarInfo_Time"].ToString();
txtOperateUser.Text = ds.Rows[0]["CarInfo_Operate"].ToString();
txtRemark.Text = ds.Rows[0]["CarInfo_Remark"].ToString();
Abnormal();
txtException.Text = abnormal;
if (!ISFill(ds))
{
return;
}
//
string caroutid = ds.Rows[0]["CarInOutRecord_ID"].ToString();
if (ds.Rows.Count > 0)
{
DataTable dt = LinQBaseDao.Query("select * from BusinessRecord where BusinessRecord_CarInOutRecord_ID=" + caroutid + "").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string type = dt.Rows[i]["BusinessRecord_Type"].ToString();
if (type == CommonalityEntity.upWeight)
{
txtInWeight.Text = dt.Rows[i]["BusinessRecord_Weight"].ToString();
}
if (type == CommonalityEntity.outWeight)
{
txtOutWeight.Text = dt.Rows[i]["BusinessRecord_Weight"].ToString();
}
}
}
}
string sqll = "Select * from CarPic where CarPic_CarInfo_ID=" + ds.Rows[0]["CarInfo_ID"].ToString();
List <CarPic> list = new List <CarPic>();
list = LinQBaseDao.GetItemsForListing <CarPic>(sqll).ToList();
int k = 0;
string path = SystemClass.SaveFile;
foreach (var pathStr in list)
{
if (k < 7)
{
PictureBox pb = new PictureBox();
int x = (20 + 165 * k);
int y = 20;
pb.Location = new Point(x, y);
pb.Width = 145;
pb.Height = 160;
pb.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;;
pb.MouseHover += new System.EventHandler(this.pbInImageOne_MouseHover);
pb.MouseLeave += new System.EventHandler(this.pbInImageOne_MouseLeave);
pb.Name = "pictureBox" + (k + 1).ToString();
pb.Tag = path + pathStr.CarPic_Add.ToString();
pb.ImageLocation = path + pathStr.CarPic_Add.ToString();
this.GroBoxContext.Controls.Add(pb);
k++;
}
}
btnSave.Enabled = true;
}
/// <summary>
/// 显示图片
/// </summary>
private void ShowImage()
{
if (string.IsNullOrEmpty(CommonalityEntity.CarInfo_ID))
{
//为空，没有绑定车辆，显示单张图片
string sql = "Select * from CarPic where CarPic_ID=" + CommonalityEntity.CarPic_ID + "";
List <CarPic> list = new List <CarPic>();
list = LinQBaseDao.GetItemsForListing <CarPic>(sql).ToList();
if (list.Count >= 1)
{
//得到图片的路径
string path = SystemClass.SaveFile;
////获取文件夹下的图片信息
//List<string> strList = ImageFile.GetImage(path, false);
//将得到的图片信息绑定到页面
int listcount = list.Count();
double wight = 0, height = 0;
int sss = 0, mmm = 0;
double doucount = Math.Sqrt(listcount);
if (Convert.ToInt32(doucount) == doucount)
{
wight = (720 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
sss = Convert.ToInt32(doucount);
}
else
{
if (doucount - (int)(doucount) == 0)
{
sss = Convert.ToInt32(doucount);
}
else
{
sss = (int)(doucount + 1);
}
wight = (720 - 10 * (sss + 2)) / Convert.ToInt32(sss);
}
height = (500 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
mmm = Math.Abs((int)(listcount / sss) - ((double)listcount / (double)sss)) == 0 ? (listcount / sss) : (int)(((double)listcount / (double)sss)) + 1;
int x = 0;
int y = 0;
gbShowImage.Controls.Clear();
int k = 0;
for (int i = 0; i < mmm; i++)
{
y = Convert.ToInt32(10 * (i + 1) + i * height) + 10;
for (int m = 0; m < sss; m++)
{
if (k >= listcount)
{
return;
}
x = Convert.ToInt32(10 * (m + 1) + m * wight) + 5;
PictureBox pb = new PictureBox();
pb.Location = new Point(x, y);
pb.Width = Convert.ToInt32(wight);
pb.Height = Convert.ToInt32(height);
pb.SizeMode = pictureBox1.SizeMode;
pb.MouseHover += new System.EventHandler(this.pbInImageOne_MouseHover);
pb.MouseLeave += new System.EventHandler(this.pbInImageOne_MouseLeave);
pb.Name = "pictureBox" + list[k].CarPic_ID.ToString();
pb.Tag = path + list[k].CarPic_Add;
pb.ImageLocation = path + list[k].CarPic_Add;
this.gbShowImage.Controls.Add(pb);
k++;
}
}
}
}
else
{
#region 已匹配的照片
string sql = "Select * from CarPic where CarPic_CarInfo_ID=" + CommonalityEntity.CarInfo_ID + "";
List <CarPic> list = new List <CarPic>();
list = LinQBaseDao.GetItemsForListing <CarPic>(sql).ToList();
if (list.Count >= 1)
{
//得到图片的路径
string path = SystemClass.SaveFile;
////获取文件夹下的图片信息
//List<string> strList = ImageFile.GetImage(path, false);
//将得到的图片信息绑定到页面
int listcount = list.Count();
double wight = 0, height = 0;
int sss = 0, mmm = 0;
double doucount = Math.Sqrt(listcount);
if (Convert.ToInt32(doucount) == doucount)
{
wight = (720 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
sss = Convert.ToInt32(doucount);
}
else
{
if (doucount - (int)(doucount) == 0)
{
sss = Convert.ToInt32(doucount);
}
else
{
sss = (int)(doucount + 1);
}
wight = (720 - 10 * (sss + 2)) / Convert.ToInt32(sss);
}
height = (500 - 10 * (doucount + 1)) / Convert.ToInt32(doucount);
mmm = Math.Abs((int)(listcount / sss) - ((double)listcount / (double)sss)) == 0 ? (listcount / sss) : (int)(((double)listcount / (double)sss)) + 1;
int x = 0;
int y = 0;
gbShowImage.Controls.Clear();
int k = 0;
for (int i = 0; i < mmm; i++)
{
y = Convert.ToInt32(10 * (i + 1) + i * height) + 10;
for (int m = 0; m < sss; m++)
{
if (k >= listcount)
{
return;
}
x = Convert.ToInt32(10 * (m + 1) + m * wight) + 5;
PictureBox pb = new PictureBox();
pb.Location = new Point(x, y);
pb.Width = Convert.ToInt32(wight);
pb.Height = Convert.ToInt32(height);
pb.SizeMode = pictureBox1.SizeMode;
pb.MouseHover += new System.EventHandler(this.pbInImageOne_MouseHover);
pb.MouseLeave += new System.EventHandler(this.pbInImageOne_MouseLeave);
pb.Name = "pictureBox" + list[k].CarPic_ID.ToString();
pb.Tag = path + list[k].CarPic_Add;
pb.ImageLocation = path + list[k].CarPic_Add;
this.gbShowImage.Controls.Add(pb);
k++;
}
}
}
#endregion
}
}
/// <summary>
/// 根据传入的sql在eh_FVN中查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static IEnumerable <CarAttribute> GetViewCarAttributeType(string sql)
{
return(LinQBaseDao.GetItemsForListing <CarAttribute>(sql));
}
/// <summary>
/// 根据传入的sql在eh_FVN中查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static IEnumerable <FVNInfo> GetViewFVNType(string sql)
{
return(LinQBaseDao.GetItemsForListing <FVNInfo>(sql));
}
private void btnCheck_Click(object sender, EventArgs e)
{
try
{
CheckProperties.ce.SapChengPinTable = null;
CheckProperties.ce.SapChengPinTable2 = null;
CheckMethod.listMessage.Clear();
CommonalityEntity.yxincheck = false;//是否系统自动进门授权
SerialNumber = txtNumber.Text.Trim();
if (string.IsNullOrEmpty(SerialNumber))
{
MessageBox.Show(this, "小票号(IC卡)不能为空");
return;
}
string strsql = "";
if (SerialNumber.Length >= 12)
{
strsql = "select top 1 * from View_CarState where SmallTicket_Serialnumber= '" + SerialNumber + "' order by SmallTicket_ID desc";
}
if (SerialNumber.Length == 9)
{
strsql = "select top 1 * from View_CarState where SmallTicket_ICCard_ID in( select ICCard_ID from ICCard where ICCard_Value ='" + SerialNumber + "') order by SmallTicket_ID desc";
ICValue = SerialNumber;
}
if (string.IsNullOrEmpty(strsql))
{
MessageBox.Show("小票号(IC卡)无效！");
return;
}
dtviewcarstate = LinQBaseDao.Query(strsql).Tables[0];
if (dtviewcarstate.Rows.Count > 0)
{
if (!ISfull())
{
return;
}
}
else
{
MessageBox.Show("小票号(IC卡)无效！");
return;
}
string Strategy_DriSName = "";//通行策略名称
CommonalityEntity.IsUpdatedri = false;
//查询车辆类型的通行策略
DataTable DrivewayStrategy_IDDT = LinQBaseDao.Query("select DrivewayStrategy_ID,DrivewayStrategy_Sort ,DrivewayStrategy_Name,DrivewayStrategy_Driveway_ID from DrivewayStrategy where DrivewayStrategy_State='启动' and DrivewayStrategy_Name in (select CarType_DriSName from CarType where CarType_Name='" + cmbCarType.Text + "') order by DrivewayStrategy_Sort ").Tables[0];
if (DrivewayStrategy_IDDT.Rows.Count <= 0)
{
MessageBox.Show("该车辆没有配通行策略！", "提示");
return;
}
Strategy_DriSName = DrivewayStrategy_IDDT.Rows[0][2].ToString();
CommonalityEntity.Driveway_ID = Convert.ToInt32(DrivewayStrategy_IDDT.Rows[0]["DrivewayStrategy_Driveway_ID"].ToString());
DataTable dtption = LinQBaseDao.Query("select Driveway_Value,Position_ID,Position_Value,Position_State from View_DrivewayPosition where Driveway_ID=" + CommonalityEntity.Driveway_ID).Tables[0];
if (dtption.Rows.Count > 0)
{
if (dtption.Rows[0]["Position_State"].ToString() != "启动")
{
MessageBox.Show(this, "通行门岗状态已暂停和注销！");
return;
}
CommonalityEntity.Driveway_Value = dtption.Rows[0]["Driveway_Value"].ToString();
CommonalityEntity.Position_ID = Convert.ToInt32(dtption.Rows[0]["Position_ID"].ToString());
CommonalityEntity.Position_Value = dtption.Rows[0]["Position_Value"].ToString();
}
else
{
MessageBox.Show(this, "门岗通道不存在，请检查！");
return;
}
string carname = dtviewcarstate.Rows[0]["CarInfo_Name"].ToString();
CheckProperties.ce.CarInfo_ID = Convert.ToInt32(dtviewcarstate.Rows[0]["CarInfo_ID"].ToString());
CheckProperties.ce.ChengPinNumber = carname;
CheckProperties.ce.carInfo_Name = carname;
if (ChkRepeat(carname))
{
MessageBox.Show("不能重复登记该车辆！");
return;
}
string crSql = "select * from CarType where CarType_Name='" + cmbCarType.Text + "'";
CheckProperties.ce.IsPhoto = false;
CheckProperties.ce.levelIsWaste = false;
CheckProperties.ce.isSort = false;
CheckProperties.ce.ISUpdateCredentials = false;
CommonalityEntity.ISYX = false;
CheckProperties.ce.IsState = false;
CarType cart = LinQBaseDao.GetItemsForListing <CarType>(crSql).FirstOrDefault();
if (cart != null)
{
CommonalityEntity.Car_Type_ID = cart.CarType_ID.ToString();
CheckProperties.ce.carType_ID = cart.CarType_ID;
CheckProperties.ce.CarTypeKey = cart.CarType_ID.ToString();
CommonalityEntity.CarType[cart.CarType_ID.ToString()] = cart.CarType_Name;
CheckProperties.ce.carType_Value = cart.CarType_Value;
CheckProperties.ce.CarType_Name = cart.CarType_Name;
}
#region 执行登记管控
//根据车辆类型，获取车辆类型的管控策略（登记管控）
string sql = "";
sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' and ManagementStrategy_Rule in('ChkChengPin', 'ChkSapOflag','ISInCheckSapSave') order by ManagementStrategy_No ";
DataTable dtmstra = LinQBaseDao.Query(sql).Tables[0];
if (dtmstra.Rows.Count > 0)
{
CommonalityEntity.ISlogin = true;
}
else
{
CommonalityEntity.ISlogin = false;
}
if (CommonalityEntity.ISlogin)
{
sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' order by ManagementStrategy_No ";
}
else
{
sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' and ManagementStrategy_Rule not in('ChkChengPin', 'ChkSapOflag','ISInCheckSapSave') order by ManagementStrategy_No ";
}
try
{
checkPr.ExecutionMethod(sql);//执行指定车辆类型的管控
}
catch { }
#endregion
//执行结果
if (CheckMethod.listMessage.Count > 0)
{
foreach (var item in CheckMethod.listMessage)
{
MessageBox.Show(item);
return;
}
}
string carId = "";
Expression <Func <Car, bool> > carFn = n => n.Car_Name == CheckProperties.ce.carInfo_Name;
Car car1 = CarDAL.Query(carFn).FirstOrDefault();
if (car1 != null)
{
carId = car1.Car_ID.ToString();
}
#region 车辆信息
carInfo_ID = insertcar(carId);
ErroSql.Add("delete carinfo where carinfo_id=" + carInfo_ID);
#endregion
#region 登记图片信息
DataTable dt = LinQBaseDao.Query("select * from CarPic where CarPic_Type='车辆登记照片' and CarPic_CarInfo_ID=" + CheckProperties.ce.CarInfo_ID).Tables[0];
if (dt.Rows.Count > 0)
{
string picSql = "Insert into CarPic(CarPic_CarInfo_ID,CarPic_State,CarPic_Add,CarPic_Type,CarPic_Time,CarPic_Match) values(" + carInfo_ID + ",'启动','" + dt.Rows[0]["CarPic_Add"].ToString() + "','车辆登记照片',getdate(),'匹配')";
picSql = picSql + " select @@identity";
string picid = LinQBaseDao.GetSingle(picSql).ToString();//得到当前的图片编号
ErroSql.Add("delete CarPic where CarPic_ID=" + picid);
}
#endregion
#region 进出凭证信息
SerialNumberNEW = CheckProperties.ce.serialNumber;
CommonalityEntity.Serialnumber = SerialNumberNEW;
SmallTicket stk = new SmallTicket();
string icid = "", count = "", hour = "";
if (!string.IsNullOrEmpty(ICValue))
{
dt = LinQBaseDao.Query("select * from ICCard where ICCard_Value='" + ICValue + "'").Tables[0];
if (dt.Rows.Count > 0)
{
string ICCard_EffectiveType = dt.Rows[0]["ICCard_EffectiveType"].ToString();
string ICCard_count = dt.Rows[0]["ICCard_count"].ToString();
string ICCard_HasCount = dt.Rows[0]["ICCard_HasCount"].ToString();
string ICCard_State = dt.Rows[0]["ICCard_State"].ToString();
icid = dt.Rows[0]["ICCard_ID"].ToString();
if (ICCard_EffectiveType == "次数")
{
int ct = Convert.ToInt32(ICCard_count);
int ht = Convert.ToInt32(ICCard_HasCount);
if (ct > ht)
{
count = (ct - ht).ToString();
}
else
{
count = "1";
}
}
if (ICCard_EffectiveType == "有效期")
{
DateTime ICCard_BeginTime = Convert.ToDateTime(dt.Rows[0]["ICCard_BeginTime"].ToString());
DateTime ICCard_EndTime = Convert.ToDateTime(dt.Rows[0]["ICCard_EndTime"].ToString());
if (CommonalityEntity.GetServersTime() > ICCard_BeginTime && CommonalityEntity.GetServersTime() < ICCard_EndTime)
{
TimeSpan th = ICCard_EndTime - CommonalityEntity.GetServersTime();
int s = Convert.ToInt32(th.TotalHours);
if (s > 0)
{
hour = s.ToString();
}
else
{
hour = "1000";
}
}
}
if (ICCard_EffectiveType == "永久")
{
count = "1";
}
}
}
else
{
hour = CheckProperties.ce.serTime;
count = CheckProperties.ce.serCount;
}
if (string.IsNullOrEmpty(count))
{
stk.SmallTicket_Allowcount = 1;
}
else
{
stk.SmallTicket_Allowcount = int.Parse(count);
}
if (string.IsNullOrEmpty(hour))
{
stk.SmallTicket_Allowhour = 0;
}
else
{
stk.SmallTicket_Allowhour = int.Parse(hour);
}
if (CheckProperties.ce.isSort)
{
//根据当前排队的序号，生成排队号
if (!CommonalityEntity.ISSecondXY)
{
DataTable dtm = LinQBaseDao.Query("select * from ManagementStrategy where ManagementStrategy_Rule='GetSortNumber' and ManagementStrategy_State='启动' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_DriSName in (select CarType_DriSName from CarType where CarType_ID=" + cmbCarType.SelectedValue + ")").Tables[0];
if (dtm.Rows.Count > 0)
{
CheckMethod.GetSortNumber();
}
string number = CommonalityEntity.SortNumber(CheckProperties.ce.sort_Value);
stk.SmallTicket_SortNumber = CommonalityEntity.Position_Value + CheckProperties.ce.carType_Value + number;
}
else
{
stk.SmallTicket_SortNumber = "";
}
}
else
{
stk.SmallTicket_SortNumber = "";
}
stk.SmallTicket_CarInfo_ID = carInfo_ID;
if (!string.IsNullOrEmpty(icid))
{
stk.SmallTicket_Type = "IC卡";
stk.SmallTicket_ICCard_ID = Convert.ToInt32(icid);
}
stk.SmallTicket_Position_ID = SystemClass.PositionID;
stk.SmallTicket_PrintNumber = "";
stk.SmallTicket_Remark = "";
stk.SmallTicket_State = "有效";
stk.SmallTicket_Time = CommonalityEntity.GetServersTime();
if (SerialNumber.Trim() != "")
{
DataTable dtm = LinQBaseDao.Query("select * from ManagementStrategy where ManagementStrategy_Rule='ChkSerialNumber' and ManagementStrategy_State='启动' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_DriSName in (select CarType_DriSName from CarType where CarType_ID=" + cmbCarType.SelectedValue + ")").Tables[0];
if (dtm.Rows.Count > 0)
{
CheckMethod.ChkSerialNumber();
SerialNumberNEW = CheckProperties.ce.serialNumber;
}
stk.SmallTicket_Type += "小票";
stk.SmallTicket_Serialnumber = SerialNumberNEW.Trim();
}
string SmalltSql = "";
if (stk.SmallTicket_ICCard_ID.ToString() != "")//判断IC卡是否输入
{
SmalltSql = "insert into SmallTicket values(" + stk.SmallTicket_ICCard_ID + ",'" + stk.SmallTicket_Serialnumber + "'," + stk.SmallTicket_Position_ID + "," + stk.SmallTicket_CarInfo_ID + ",'" + stk.SmallTicket_Time + "','" + stk.SmallTicket_SortNumber + "','" + stk.SmallTicket_PrintNumber + "','" + stk.SmallTicket_State + "','" + stk.SmallTicket_Type + "','" + stk.SmallTicket_Allowcounted + "','" + stk.SmallTicket_Allowcount + "','" + stk.SmallTicket_Allowhour + "','" + stk.SmallTicket_Remark + "')";
}
else
{
SmalltSql = "insert into SmallTicket values(null,'" + stk.SmallTicket_Serialnumber + "'," + stk.SmallTicket_Position_ID + "," + stk.SmallTicket_CarInfo_ID + ",'" + stk.SmallTicket_Time + "','" + stk.SmallTicket_SortNumber + "','" + stk.SmallTicket_PrintNumber + "','" + stk.SmallTicket_State + "','" + stk.SmallTicket_Type + "','" + stk.SmallTicket_Allowcounted + "','" + stk.SmallTicket_Allowcount + "','" + stk.SmallTicket_Allowhour + "','" + stk.SmallTicket_Remark + "')";
}
SmalltSql = SmalltSql + " select @@identity";
smallTicket_ID = int.Parse(LinQBaseDao.GetSingle(SmalltSql).ToString());//得到当前的车辆编号
ErroSql.Add("delete SmallTicket where SmallTicket_id=" + smallTicket_ID);
#endregion
#region 排队信息
SortNumberInfo sort = new SortNumberInfo();
//根据车辆类型 得到该车辆类型的信息
sort.SortNumberInfo_DrivewayValue = CommonalityEntity.Driveway_Value;
//门岗值
sort.SortNumberInfo_PositionValue = CommonalityEntity.Position_Value;
//车辆类型值
sort.SortNumberInfo_CarTypeValue = CheckProperties.ce.carType_Value;
//呼叫次数
sort.SortNumberInfo_CallCount = 0;
sort.SortNumberInfo_LEDCount = 0;
sort.SortNumberInfo_Operate = CommonalityEntity.USERNAME;
//生成原因
sort.SortNumberInfo_Reasons = "登记生成";
sort.SortNumberInfo_Remark = "";
//凭证编号
sort.SortNumberInfo_SmallTicket_ID = smallTicket_ID;
sort.SortNumberInfo_SMSCount = 0;
if (CheckProperties.ce.isSort)
{
if (!CommonalityEntity.ISSecondXY)
{
sort.SortNumberInfo_SortValue = CheckProperties.ce.sort_Value + 1;
sort.SortNumberInfo_TongXing = "排队中";
}
else
{
CommonalityEntity.ISSecondXY = false;
sort.SortNumberInfo_SortValue = null;
sort.SortNumberInfo_TongXing = "待通行";
}
}
else
{
sort.SortNumberInfo_SortValue = null;
sort.SortNumberInfo_TongXing = "待通行";
}
sort.SortNumberInfo_State = "启动";
sort.SortNumberInfo_Type = "系统生成";
sort.SortNumberInfo_Time = CommonalityEntity.GetServersTime();
//添加排队信息
string sort_Sql = "insert into SortNumberInfo values('" + sort.SortNumberInfo_SmallTicket_ID + "','" + sort.SortNumberInfo_Time + "','" + sort.SortNumberInfo_Reasons + "','" + sort.SortNumberInfo_Operate + "','" + sort.SortNumberInfo_Type + "','" + sort.SortNumberInfo_SortValue + "','" + sort.SortNumberInfo_PositionValue + "','" + sort.SortNumberInfo_CarTypeValue + "','" + sort.SortNumberInfo_CallCount + "','" + sort.SortNumberInfo_SMSCount + "','" + sort.SortNumberInfo_LEDCount + "','" + sort.SortNumberInfo_Remark + "','" + sort.SortNumberInfo_TongXing + "','" + sort.SortNumberInfo_DrivewayValue + "','" + sort.SortNumberInfo_State + "','" + sort.SortNumberInfo_CallTime + "','" + sort.SortNumberInfo_Number + "', 1 ,0)";
sort_Sql = sort_Sql + " select @@identity";
sortNumberInfo_ID = int.Parse(LinQBaseDao.GetSingle(sort_Sql).ToString());
ErroSql.Add("delete SortNumberInfo where SortNumberInfo_ID=" + sortNumberInfo_ID);//增删改出错后需要执行的SQL
#endregion
#region 添加通行总记录
CarInOutRecord cir = new CarInOutRecord();
string strstrategy = "";
bool issort = false;
cir.CarInOutRecord_DrivewayStrategy_ID = Convert.ToInt32(DrivewayStrategy_IDDT.Rows[0]["DrivewayStrategy_ID"].ToString());
for (int i = 0; i < DrivewayStrategy_IDDT.Rows.Count; i++)
{
if (Convert.ToInt32(DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_Sort"].ToString()) == 1)
{
issort = false;
strstrategy += DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_ID"].ToString() + ",";
}
else
{
issort = true;
strstrategy += DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_ID"].ToString() + ",";
}
}
cir.CarInOutRecord_ISFulfill = false;
cir.CarInOutRecord_Abnormal = "正常";
cir.CarInOutRecord_State = "启动";
cir.CarInOutRecord_DrivewayStrategyS = strstrategy.TrimEnd(',');
cir.CarInOutRecord_CarInfo_ID = carInfo_ID;
cir.CarInOutRecord_Update = false;
cir.CarInOutRecord_Driveway_ID = CommonalityEntity.Driveway_ID;
if (issort)
{
cir.CarInOutRecord_Sort = "有序";
}
else
{
cir.CarInOutRecord_Sort = "无序";
}
string CarInOutRecordSql = "Insert into CarInOutRecord(CarInOutRecord_CarInfo_ID,CarInOutRecord_DrivewayStrategy_ID,CarInOutRecord_ISFulfill,CarInOutRecord_Time,CarInOutRecord_Abnormal,CarInOutRecord_State,CarInOutRecord_DrivewayStrategyS,CarInOutRecord_Sort,CarInOutRecord_Update,CarInOutRecord_Driveway_ID,CarInOutRecord_InCheck,CarInOutRecord_Remark) values(" + cir.CarInOutRecord_CarInfo_ID + "," + cir.CarInOutRecord_DrivewayStrategy_ID + ",'" + cir.CarInOutRecord_ISFulfill + "',getdate(),'正常','启动','" + cir.CarInOutRecord_DrivewayStrategyS + "','" + cir.CarInOutRecord_Sort + "','" + cir.CarInOutRecord_Update + "'," + cir.CarInOutRecord_Driveway_ID + ",'否','" + Strategy_DriSName + "')";
CarInOutRecordSql = CarInOutRecordSql + " select @@identity";
CarInOutRecord_ID = int.Parse(LinQBaseDao.GetSingle(CarInOutRecordSql).ToString());
ErroSql.Add("delete CarInOutRecord where CarInOutRecord_ID=" + CarInOutRecord_ID);
#endregion
#region 添加关联表信息
string staid = dtviewcarstate.Rows[0]["StaffInfo_ID"].ToString();
string sfCrSql = "Insert into StaffInfo_CarInfo values(" + staid + "," + smallTicket_ID + ")";
sfCrSql = sfCrSql + " select @@identity";
int sfCrID = int.Parse(LinQBaseDao.GetSingle(sfCrSql).ToString());
ErroSql.Add("delete StaffInfo_CarInfo where StaffInfo_CarInfo_ID=" + sfCrID);
#endregion
if (CommonalityEntity.yxincheck)
{
LinQBaseDao.Query("update CarInOutRecord set CarInOutRecord_InCheck='是',CarInOutRecord_InCheckTime=GETDATE(),CarInOutRecord_InCheckUser='******' where CarInOutRecord_ID=" + CarInOutRecord_ID);
}
#region 判断是否添加成功
if (sortNumberInfo_ID > 0 && smallTicket_ID > 0 && carInfo_ID > 0 && CarInOutRecord_ID != -1)
{
if (CommonalityEntity.SAP_ID != "" && SerialNumberNEW != "")
{
LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + SerialNumberNEW + " where Sap_ID=" + CommonalityEntity.SAP_ID);
CommonalityEntity.SAP_ID = "";
if (!CommonalityEntity.GetSAP(PNO, "A", carname, SerialNumberNEW, "1"))
{
MessageBox.Show("成品纸车辆SAP验证未通过！");
return;
}
}
if (CommonalityEntity.SAP_ID != "" && SerialNumberNEW == "" && ICValue != "")
{
LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + ICValue + " where Sap_ID=" + CommonalityEntity.SAP_ID);
CommonalityEntity.SAP_ID = "";
if (!CommonalityEntity.GetSAP(PNO, "A", carname, ICValue, "1"))
{
MessageBox.Show("成品纸车辆SAP验证未通过！");
return;
}
}
CommonalityEntity.CarInfo_ID = carInfo_ID.ToString();
MessageBox.Show(this, "成品二次排队成功");
CommonalityEntity.WriteLogData("新增", "新增：" + carname + "车辆二次排队", CommonalityEntity.USERNAME);//添加操作日志
if (!string.IsNullOrEmpty(CommonalityEntity.SAP_ID))
{
DataTable dtsap = LinQBaseDao.Query("select Sap_InNO,Sap_OutHG,Sap_OutXZ from eh_SAPRecord where Sap_ID=" + CommonalityEntity.SAP_ID).Tables[0];
if (dtsap.Rows.Count > 0)
{
if (CommonalityEntity.SAP_ID != "" && SerialNumber != "")
{
LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + SerialNumberNEW + " where Sap_ID=" + CommonalityEntity.SAP_ID);
CommonalityEntity.SAP_ID = "";
if (!CommonalityEntity.GetSAP(dtsap.Rows[0]["Sap_InNO"].ToString(), "A", carname, SerialNumberNEW, "1"))
{
MessageBox.Show("成品车辆SAP验证未通过！");
return;
}
}
}
}
//获取打印设置
string prtSql = "select top 1 * from PrintInfo where Print_State='启动' and Print_CarType_ID=" + CheckProperties.ce.carType_ID + "";
if (CheckProperties.ce.isSerialNumber)
{
CheckProperties.ce.isSerialNumber = false;
PrintInfo pinfo = PrintInfoDAL.GetPrint(prtSql);
if (pinfo.Print_ID > 0)
{
if (SerialNumberNEW != "")
{
string prSql = "Select top 1 ";
string[] str = pinfo.Print_Content.Split(',');
foreach (var item in str)
{
prSql += item + ",";
}
prSql = prSql.Substring(0, prSql.Length - 1);
prSql += " from View_LEDShow_zj where 小票号='" + SerialNumberNEW + "' and smallTicket_State='有效'";
DataSet ds = LinQBaseDao.Query(prSql);
CommonalityEntity.Serialnumber = SerialNumberNEW;
PrintInfoForm pi = new PrintInfoForm(ds);
pi.Show();
}
}
else
{
MessageBox.Show("没有进行打印设置，请设置打印后，重新打印");
return;
}
}
}
#endregion
}
catch
{
MessageBox.Show("成品二次排队失败！");
CommonalityEntity.WriteTextLog("ProductForm btnCheck_Click()");
try
{
string sqlstr = "";
for (int i = 0; i < ErroSql.Count; i++)
{
sqlstr += ErroSql[i] + " ";
}
LinQBaseDao.Query(sqlstr);
}
catch
{
CommonalityEntity.WriteTextLog("ProductForm btnCheck_Click()");
}
}
}
/// 添加车辆信息
/// </summary>
/// <param name="strid">车辆基础信息ID</param>
/// <returns></returns>
private int insertcar(string strid)
{
string CarName = "";
string pno = "";
string CarInfo_Carriage = "";
string CustomerInfoName = "";
string chkCarInfo_Bail = "";
string txtCarInfo_Height = "";
string txtCarInfo_Weight = "";
if (!string.IsNullOrEmpty(CommonalityEntity.SAP_ID))
{
string sql = "Select * from eh_Saprecord where SAP_ID =" + CommonalityEntity.SAP_ID;
List <eh_SAPRecord> list = LinQBaseDao.GetItemsForListing <eh_SAPRecord>(sql).ToList();
if (list != null)
{
eh_SAPRecord item = list[0];
if (!string.IsNullOrEmpty(item.Sap_InNO))
{
pno = item.Sap_InNO;//送货单号
PNO = pno;
}
DataTable dt;
if (item.Sap_InCarNumber != null || item.Sap_InCarNumber != "")
{
CarName = item.Sap_InCarNumber;//车牌号
}
if (item.Sap_OutNAME1C != null || item.Sap_OutNAME1C != "")
{
CustomerInfoName = item.Sap_OutNAME1C;//客户
}
if (item.Sap_OutNAME1C == null || item.Sap_OutNAME1C == "")
{
if (item.Sap_OutNAME1P != "" || item.Sap_OutNAME1P != null)
{
CustomerInfoName = item.Sap_OutNAME1P;//供应商
}
}
if (CustomerInfoName != "")
{
DataTable CustomerInfo_IDDT = LinQBaseDao.Query("select CustomerInfo_ID from CustomerInfo where CustomerInfo_Name='" + CustomerInfoName + "'").Tables[0];
//如果数据库有就赋值没有就添加
if (CustomerInfo_IDDT.Rows.Count > 0)
{
CustomerInfo_ID = CustomerInfo_IDDT.Rows[0][0].ToString();
}
else
{
CustomerInfo_ID = LinQBaseDao.GetSingle("insert CustomerInfo(CustomerInfo_Name,CustomerInfo_State,CustomerInfo_Time) values('" + CustomerInfoName + "','启动',GETDATE()) select @@identity").ToString();
}
}
if (item.Sap_OutMAKTX != null || item.Sap_OutMAKTX != "")
{
CarInfo_Carriage = item.Sap_OutMAKTX;//物料描述
}
if (item.Sap_OutOFLAG != null || item.Sap_OutOFLAG != "")
{
if (item.Sap_OutOFLAG == "X")
{
chkCarInfo_Bail = "True";
}
else
{
chkCarInfo_Bail = "False";
}
}
if (item.Sap_OutHG != null || item.Sap_OutHG != "")
{
txtCarInfo_Height = item.Sap_OutHG;
}
if (item.Sap_OutXZ != null || item.Sap_OutXZ != "")
{
txtCarInfo_Weight = item.Sap_OutXZ;
}
}
}
else
{
chkCarInfo_Bail = "False";
CarName = dtviewcarstate.Rows[0]["CarInfo_Name"].ToString();
CustomerInfo_ID = dtviewcarstate.Rows[0]["CustomerInfo_ID"].ToString();
}
int str = 0;
#region 车辆信息
CarInfo carInfo = new CarInfo();
//得到车辆类型编号
carInfo.CarInfo_CarType_ID = CheckProperties.ce.carType_ID;
//车牌号
carInfo.CarInfo_Name = CarName;
carInfo.CarInfo_State = "启动";
carInfo.CarInfo_Remark = "成品二次排队";
carInfo.CarInfo_Carriage = CarInfo_Carriage;
carInfo.CarInfo_Height = txtCarInfo_Height;
carInfo.CarInfo_Weight = txtCarInfo_Weight;
carInfo.CarInfo_Car_ID = Convert.ToInt32(strid);
//公司编号
if (!string.IsNullOrEmpty(CustomerInfo_ID))
{
carInfo.CarInfo_CustomerInfo_ID = int.Parse(CustomerInfo_ID);
}
carInfo.CarInfo_Operate = CommonalityEntity.USERNAME;
carInfo.CarInfo_Time = CommonalityEntity.GetServersTime();
carInfo.CarInfo_Bail = chkCarInfo_Bail;
carInfo.CarInfo_PO = pno;
string carSql = "insert into CarInfo(CarInfo_CustomerInfo_ID,CarInfo_CarType_ID,CarInfo_Name,CarInfo_State,CarInfo_Carriage,CarInfo_Weight,CarInfo_Height,CarInfo_Bail,CarInfo_PO,CarInfo_Time,CarInfo_Remark,CarInfo_Operate,CarInfo_Car_ID) values(" + carInfo.CarInfo_CustomerInfo_ID + "," + carInfo.CarInfo_CarType_ID + ",'" + carInfo.CarInfo_Name + "','" + carInfo.CarInfo_State + "','" + carInfo.CarInfo_Carriage + "','" + carInfo.CarInfo_Weight + "','" + carInfo.CarInfo_Height + "','" + carInfo.CarInfo_Bail + "','" + carInfo.CarInfo_PO + "','" + carInfo.CarInfo_Time + "','" + carInfo.CarInfo_Remark + "','" + carInfo.CarInfo_Operate + "'," + strid + ")";
carSql = carSql + " select @@identity";
str = int.Parse(LinQBaseDao.GetSingle(carSql).ToString());//得到当前的车辆编号
#endregion
return(str);
}
/// <summary>
/// 根据传入的sql在eh_Driveway中查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static IEnumerable <Driveway> GetViewDrivewayName(string sql)
{
return(LinQBaseDao.GetItemsForListing <Driveway>(sql));
}
/// <summary>
/// 根据传入的sql在eh_FVN中查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static IEnumerable <BusinessType> GetViewBusinessType(string sql)
{
return(LinQBaseDao.GetItemsForListing <BusinessType>(sql));
}