/// <summary>
/// 增加一条数据
/// </summary>
public string Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_CheckBang model)
{
#region 重车验票
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TT_CheckBang(");
strSql.Append("CheckCode,WeightCode,NavicertCode,MarkedCardCode,NetWeight,RoomCode,IsPassed,CheckResult,CheckTime,Operator,FrontImage,BackImage,UpImage,RoomImage)");
strSql.Append(" values (");
strSql.Append("@CheckCode,@WeightCode,@NavicertCode,@MarkedCardCode,@NetWeight,@RoomCode,@IsPassed,@CheckResult,@CheckTime,@Operator,@FrontImage,@BackImage,@UpImage,@RoomImage)");
SqlParameter[] parameters = {
new SqlParameter("@CheckCode", SqlDbType.VarChar,20),
new SqlParameter("@WeightCode", SqlDbType.VarChar,20),
new SqlParameter("@NavicertCode", SqlDbType.VarChar,20),
new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20),
new SqlParameter("@NetWeight", SqlDbType.Decimal,9),
new SqlParameter("@RoomCode", SqlDbType.VarChar,10),
new SqlParameter("@IsPassed", SqlDbType.VarChar,1),
new SqlParameter("@CheckResult", SqlDbType.NVarChar,200),
new SqlParameter("@CheckTime", SqlDbType.DateTime),
new SqlParameter("@Operator", SqlDbType.NVarChar,20),
new SqlParameter("@FrontImage",SqlDbType.VarChar,32),
new SqlParameter("@BackImage",SqlDbType.VarChar,32),
new SqlParameter("@UpImage",SqlDbType.VarChar,32),
new SqlParameter("@RoomImage",SqlDbType.VarChar,32)
};
parameters[0].Value = model.CheckCode;
parameters[1].Value = model.WeightCode;
parameters[2].Value = model.NavicertCode;
parameters[3].Value = model.MarkedCardCode;
parameters[4].Value = model.NetWeight;
parameters[5].Value = model.RoomCode;
parameters[6].Value = model.IsPassed;
parameters[7].Value = model.CheckResult;
parameters[8].Value = model.CheckTime;
parameters[9].Value = model.Operator;
parameters[10].Value = model.FrontImage;
parameters[11].Value = model.BackImage;
parameters[12].Value = model.UpImage;
parameters[13].Value = model.RoomImage;
#endregion
List<CommandInfo> LC = new List<CommandInfo>();
CommandInfo CIBadRecord = new CommandInfo();
CIBadRecord.CommandText = strSql.ToString();
CIBadRecord.Parameters = parameters;
LC.Add(CIBadRecord);
#region 插入报警图片
string strInsertImage = "insert into Sys_FileSave (FileCode,FileName,FileType,FileContent) values(@FileCode,@FileName,@FileType,@FileContent);";
#endregion
if (model.FrontImageContent != null)
{
#region 车前视频
SqlParameter[] Frontparam = {
new SqlParameter("@FileCode",SqlDbType.VarChar,32),
new SqlParameter("@FileName",SqlDbType.NVarChar,50),
new SqlParameter("@FileType",SqlDbType.VarChar,50),
new SqlParameter("@FileContent",SqlDbType.Image)
};
Frontparam[0].Value = model.FrontImage;
Frontparam[1].Value = "车前视频";
Frontparam[2].Value = ".jpg";
Frontparam[3].Value = model.FrontImageContent;
#endregion
CommandInfo CIFrontImage = new CommandInfo();
CIFrontImage.CommandText = strInsertImage;
CIFrontImage.Parameters = Frontparam;
LC.Add(CIFrontImage);
}
if (model.BackImageContent != null)
{
#region 车后视频
SqlParameter[] Backparam = {
new SqlParameter("@FileCode",SqlDbType.VarChar,32),
new SqlParameter("@FileName",SqlDbType.NVarChar,50),
new SqlParameter("@FileType",SqlDbType.VarChar,50),
new SqlParameter("@FileContent",SqlDbType.Image)
};
Backparam[0].Value = model.BackImage;
Backparam[1].Value = "车后视频";
Backparam[2].Value = ".jpg";
Backparam[3].Value = model.BackImageContent;
#endregion
CommandInfo CIBackImage = new CommandInfo();
CIBackImage.CommandText = strInsertImage;
CIBackImage.Parameters = Backparam;
LC.Add(CIBackImage);
}
if (model.UpImageContent != null)
{
#region 车厢视频
SqlParameter[] Uparam = {
new SqlParameter("@FileCode",SqlDbType.VarChar,32),
new SqlParameter("@FileName",SqlDbType.NVarChar,50),
new SqlParameter("@FileType",SqlDbType.VarChar,50),
new SqlParameter("@FileContent",SqlDbType.Image)
};
Uparam[0].Value = model.UpImage;
Uparam[1].Value = "车厢视频";
Uparam[2].Value = ".jpg";
Uparam[3].Value = model.UpImageContent;
#endregion
CommandInfo CIUpImage = new CommandInfo();
CIUpImage.CommandText = strInsertImage;
CIUpImage.Parameters = Uparam;
LC.Add(CIUpImage);
}
if (model.RoomImageContent != null)
{
#region 室内视频
SqlParameter[] Roomparam = {
new SqlParameter("@FileCode",SqlDbType.VarChar,32),
new SqlParameter("@FileName",SqlDbType.NVarChar,50),
new SqlParameter("@FileType",SqlDbType.VarChar,50),
new SqlParameter("@FileContent",SqlDbType.Image)
};
Roomparam[0].Value = model.RoomImage;
Roomparam[1].Value = "室内视频";
Roomparam[2].Value = ".jpg";
Roomparam[3].Value = model.RoomImageContent;
#endregion
CommandInfo CIRoomImage = new CommandInfo();
CIRoomImage.CommandText = strInsertImage;
CIRoomImage.Parameters = Roomparam;
LC.Add(CIRoomImage);
}
int iAffected = DbHelperSQL.ExecuteSqlTran(LC);
return iAffected > 0 ? model.CheckCode : "";
}
public int ForBid(string strMCode, string strValue)
{
List<CommandInfo> LCI = new List<CommandInfo>();
string strUpdatesql = "update TT_MessagePerson set IsForBid = '" + strValue + "' where MCode in (" + strMCode + ");";
string strCollierySupervise = "update TT_CollierySupervise set IsForBid = '" + strValue + "' where MCode in (" + strMCode + ");";
string strRoomSupervise = "update TT_RoomSupervise set IsForBid = '" + strValue + "' where MCode in (" + strMCode + ");";
string strSupervise = "update TT_Supervise set IsForBid = '" + strValue + "' where MCode in (" + strMCode + ");";
CommandInfo CI = new CommandInfo();
CI.CommandText = strUpdatesql;
CI.Parameters = null;
LCI.Add(CI);
CommandInfo CICollierySupervise = new CommandInfo();
CICollierySupervise.CommandText = strCollierySupervise;
CICollierySupervise.Parameters = null;
LCI.Add(CICollierySupervise);
CommandInfo CIRoomSupervise = new CommandInfo();
CIRoomSupervise.CommandText = strRoomSupervise;
CIRoomSupervise.Parameters = null;
LCI.Add(CIRoomSupervise);
CommandInfo CISupervise = new CommandInfo();
CISupervise.CommandText = strSupervise;
CISupervise.Parameters = null;
LCI.Add(CISupervise);
if (System.Configuration.ConfigurationManager.AppSettings["IsAddLog"] == "1")
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_OperateLog(");
strSql.Append("LogType,OperateTable,Operator,OperateDate,OperateIP,RelationID,Remark,SysCode)");
strSql.Append(" values (");
strSql.Append("@LogType,@OperateTable,@Operator,CONVERT(varchar,getdate(),120),@OperateIP,@RelationID,@Remark,'s2000')");
string[] array = strMCode.Split(',');
for (int i = 0; i < array.Length; i++)
{
SqlParameter[] parametersi = {
new SqlParameter("@LogType", SqlDbType.NVarChar,18),
new SqlParameter("@OperateTable", SqlDbType.VarChar,32),
new SqlParameter("@Operator", SqlDbType.NVarChar,50),
new SqlParameter("@OperateIP", SqlDbType.Char,18),
new SqlParameter("@RelationID", SqlDbType.Char,32),
new SqlParameter("@Remark", SqlDbType.NVarChar,200)};
parametersi[0].Value = strValue == "1" ? "禁用" : "启用";
parametersi[1].Value = "TT_MessagePerson";
parametersi[2].Value = CookieManager.GetCookieValue("UserName");
parametersi[3].Value =System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
parametersi[4].Value = array[i].Trim(',');
parametersi[5].Value = "";
CommandInfo CIi = new CommandInfo();
CIi.CommandText = strSql.ToString();
CIi.Parameters = parametersi;
LCI.Add(CIi);
}
}
return DbHelperSQL.ExecuteSqlTran(LCI);
}
