/// <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); }