/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxAssignDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_TaxAssignDetail("); strSql.Append("ItemDetailID,UnitCode,AssignAmount,OperateTime,Operator)"); strSql.Append(" values ("); strSql.Append("@ItemDetailID,@UnitCode,@AssignAmount,@OperateTime,@Operator)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ItemDetailID", SqlDbType.Decimal,9), new SqlParameter("@UnitCode", SqlDbType.VarChar,10), new SqlParameter("@AssignAmount", SqlDbType.Decimal,9), new SqlParameter("@OperateTime", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar,20)}; parameters[0].Value = model.ItemDetailID; parameters[1].Value = model.UnitCode; parameters[2].Value = model.AssignAmount; parameters[3].Value = model.OperateTime; parameters[4].Value = model.Operator; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TDTK.PlatForm.MVC4.Model.TT_TaxItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TT_TaxItem set "); strSql.Append("ItemName=@ItemName,"); strSql.Append("ItemType=@ItemType,"); strSql.Append("IsCount=@IsCount,"); strSql.Append("IsForbid=@IsForbid,"); strSql.Append("Remark=@Remark"); strSql.Append(" where TaxItemCode=@TaxItemCode "); SqlParameter[] parameters = { new SqlParameter("@ItemName", SqlDbType.NVarChar,50), new SqlParameter("@ItemType", SqlDbType.VarChar,10), new SqlParameter("@IsCount", SqlDbType.VarChar,1), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@TaxItemCode", SqlDbType.VarChar,10)}; parameters[0].Value = model.ItemName; parameters[1].Value = model.ItemType; parameters[2].Value = model.IsCount; parameters[3].Value = model.IsForbid; parameters[4].Value = model.Remark; parameters[5].Value = model.TaxItemCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.PlatForm.MVC4.Model.TT_TaxUnit model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_TaxUnit("); strSql.Append("UnitCode,UnitName,Remark,IsForbid)"); strSql.Append(" values ("); strSql.Append("@UnitCode,@UnitName,@Remark,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@UnitCode", SqlDbType.VarChar,10), new SqlParameter("@UnitName", SqlDbType.NVarChar,50), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.UnitCode; parameters[1].Value = model.UnitName; parameters[2].Value = model.Remark; parameters[3].Value = model.IsForbid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return rows; } else { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItem model) { try { List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_TaxItem("); strSql.Append("TaxItemCode,ItemName,ItemType,IsCount,IsForbid,Remark)"); strSql.Append(" values ("); strSql.Append("@TaxItemCode,@ItemName,@ItemType,@IsCount,@IsForbid,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@TaxItemCode", SqlDbType.VarChar,10), new SqlParameter("@ItemName", SqlDbType.NVarChar,50), new SqlParameter("@ItemType", SqlDbType.Char,10), new SqlParameter("@IsCount", SqlDbType.Char,1), new SqlParameter("@IsForbid", SqlDbType.Char,1), new SqlParameter("@Remark", SqlDbType.NVarChar,200)}; parameters[0].Value = model.TaxItemCode; parameters[1].Value = model.ItemName; parameters[2].Value = model.ItemType; parameters[3].Value = model.IsCount; parameters[4].Value = model.IsForbid; parameters[5].Value = model.Remark; listSql.Add(strSql.ToString()); listParm.Add(parameters); if (System.Configuration.ConfigurationManager.AppSettings["IsAddLog"] == "1") { 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,'s1000')"); SqlParameter[] parameters1 = { new SqlParameter("@LogType", SqlDbType.NVarChar,50), new SqlParameter("@OperateTable", SqlDbType.VarChar,50), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@OperateIP", SqlDbType.Char,15), new SqlParameter("@RelationID", SqlDbType.VarChar,20), new SqlParameter("@Remark", SqlDbType.NVarChar,200)}; parameters1[0].Value = "添加"; parameters1[1].Value = "TT_TaxItem"; parameters1[2].Value = CookieManager.GetCookieValue("UserName"); parameters1[3].Value = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; ; parameters1[4].Value = model.TaxItemCode; parameters1[5].Value = ""; listSql.Add(strSql.ToString()); listParm.Add(parameters1); } return DbHelperSQL.ExecuteSqlCake(listSql, listParm) == true ? 1 : 0; } catch { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.PlatForm.MVC4.Model.CardLogin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CardLogin("); strSql.Append("CardID,UserName,UserCode)"); strSql.Append(" values ("); strSql.Append("@CardID,@UserName,@UserCode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.VarChar,20), new SqlParameter("@UserName", SqlDbType.NVarChar,50), new SqlParameter("@UserCode", SqlDbType.NVarChar,50)}; parameters[0].Value = model.CardID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows>0) { return rows; } else { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.PlatForm.MVC4.Model.TT_TransferAccounts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_TransferAccounts("); strSql.Append("FromCollCode,ToCollCode,TransferMoney,Operator,OperateTime,OrgName)"); strSql.Append(" values ("); strSql.Append("@FromCollCode,@ToCollCode,@TransferMoney,@Operator,@OperateTime,@OrgName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FromCollCode", SqlDbType.VarChar,10), new SqlParameter("@ToCollCode", SqlDbType.VarChar,10), new SqlParameter("@TransferMoney", SqlDbType.Decimal,9), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@OperateTime", SqlDbType.DateTime), new SqlParameter("@OrgName", SqlDbType.NVarChar,20)}; parameters[0].Value = model.FromCollCode; parameters[1].Value = model.ToCollCode; parameters[2].Value = model.TransferMoney; parameters[3].Value = model.Operator; parameters[4].Value = model.OperateTime; parameters[5].Value = model.OrgName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows>0) { return rows; } else { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_BadHandle model) { List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_BadHandle("); strSql.Append("HandleID,BadRecordID,Operator,OperateDate,Result,HandleOperator,HandleDate)"); strSql.Append(" values ("); strSql.Append("@HandleID,@BadRecordID,@Operator,@OperateDate,@Result,@HandleOperator,@HandleDate)"); SqlParameter[] parameters = { new SqlParameter("@HandleID", SqlDbType.VarChar,32), new SqlParameter("@BadRecordID", SqlDbType.VarChar,32), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@OperateDate", SqlDbType.DateTime), new SqlParameter("@Result", SqlDbType.NVarChar,200), new SqlParameter("@HandleOperator", SqlDbType.NVarChar,20), new SqlParameter("@HandleDate", SqlDbType.DateTime) }; parameters[0].Value = model.HandleID; parameters[1].Value = model.BadRecordID; parameters[2].Value = model.Operator; parameters[3].Value = model.OperateDate; parameters[4].Value = model.Result; parameters[5].Value = model.HandleOperator; parameters[6].Value = model.HandleDate; listSql.Add(strSql.ToString()); listParm.Add(parameters); listSql.Add("Update TT_BadRecord set AlarmStatus='1' where RecordID='" + model.BadRecordID + "'"); listParm.Add(null); return DbHelperSQL.ExecuteSqlCake(listSql, listParm); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_CollierySupervise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_CollierySupervise("); strSql.Append("CSCode,CollCode,MCode,MPName,PhoneNumber,ReceiveTypeCode,IsForBid)"); strSql.Append(" values ("); strSql.Append("@CSCode,@CollCode,@MCode,@MPName,@PhoneNumber,@ReceiveTypeCode,@IsForBid)"); SqlParameter[] parameters = { new SqlParameter("@CSCode", SqlDbType.VarChar,4), new SqlParameter("@CollCode", SqlDbType.VarChar,4), new SqlParameter("@MCode", SqlDbType.VarChar,4), new SqlParameter("@MPName", SqlDbType.NVarChar,20), new SqlParameter("@PhoneNumber", SqlDbType.VarChar,13), new SqlParameter("@ReceiveTypeCode", SqlDbType.VarChar,2), new SqlParameter("@IsForBid", SqlDbType.VarChar,1)}; parameters[0].Value = model.CSCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.Mcode; parameters[3].Value = model.MPName; parameters[4].Value = model.PhoneNumber; parameters[5].Value = model.ReceiveTypeCode; parameters[6].Value = model.Isforbid; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TDTK.PlatForm.MVC4.Model.CardLogin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CardLogin set "); strSql.Append("CardID=@CardID,"); strSql.Append("UserName=@UserName,"); strSql.Append("UserCode=@UserCode"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.VarChar,20), new SqlParameter("@UserName", SqlDbType.NVarChar,50), new SqlParameter("@UserCode", SqlDbType.NVarChar,50), new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = model.CardID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserCode; parameters[3].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TDTK.PlatForm.MVC4.Model.TT_TwoPrintLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TT_TwoPrintLog set "); strSql.Append("LogType=@LogType,"); strSql.Append("Operator=@Operator,"); strSql.Append("PrintDate=@PrintDate,"); strSql.Append("PrintTable=@PrintTable,"); strSql.Append("PrintWeightCode=@PrintWeightCode"); strSql.Append(" where LogID=@LogID "); SqlParameter[] parameters = { new SqlParameter("@LogType", SqlDbType.NVarChar,50), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@PrintDate", SqlDbType.DateTime), new SqlParameter("@PrintTable", SqlDbType.NVarChar,50), new SqlParameter("@PrintWeightCode", SqlDbType.VarChar,20), new SqlParameter("@LogID", SqlDbType.VarChar,32)}; parameters[0].Value = model.LogType; parameters[1].Value = model.Operator; parameters[2].Value = model.PrintDate; parameters[3].Value = model.PrintTable; parameters[4].Value = model.PrintWeightCode; parameters[5].Value = model.LogID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.PlatForm.MVC4.Model.TT_TwoPrintLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_TwoPrintLog("); strSql.Append("LogID,LogType,Operator,PrintDate,PrintTable,PrintWeightCode)"); strSql.Append(" values ("); strSql.Append("@LogID,@LogType,@Operator,@PrintDate,@PrintTable,@PrintWeightCode)"); SqlParameter[] parameters = { new SqlParameter("@LogID", SqlDbType.VarChar,32), new SqlParameter("@LogType", SqlDbType.NVarChar,50), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@PrintDate", SqlDbType.DateTime), new SqlParameter("@PrintTable", SqlDbType.NVarChar,50), new SqlParameter("@PrintWeightCode", SqlDbType.VarChar,20)}; parameters[0].Value = model.LogID; parameters[1].Value = model.LogType; parameters[2].Value = model.Operator; parameters[3].Value = model.PrintDate; parameters[4].Value = model.PrintTable; parameters[5].Value = model.PrintWeightCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return rows; } else { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_MarkedCardSendLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_MarkedCardSendLog("); strSql.Append("LogID,CollieryID,KindCode,SendCount,OperateaDate,OperatorID,Remark)"); strSql.Append(" values ("); strSql.Append("@LogID,@CollieryID,@KindCode,@SendCount,@OperateaDate,@OperatorID,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@LogID", SqlDbType.VarChar,32), new SqlParameter("@CollieryID", SqlDbType.Decimal,9), new SqlParameter("@KindCode", SqlDbType.VarChar,4), new SqlParameter("@SendCount", SqlDbType.Decimal,9), new SqlParameter("@OperateaDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Decimal,9), new SqlParameter("@Remark", SqlDbType.NVarChar,200)}; parameters[0].Value = model.LogID; parameters[1].Value = model.CollieryID; parameters[2].Value = model.KindCode; parameters[3].Value = model.SendCount; parameters[4].Value = model.OperateaDate; parameters[5].Value = model.OperatorID; parameters[6].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public int UpdateCollieryGIS(TDTK.IndustryPlatform.SafetyMonitor.Model.GIS_Colliery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GIS_Colliery set "); strSql.Append("SmX=@SmX,"); strSql.Append("SmY=@SmY,"); strSql.Append("UserID=@UserID,"); strSql.Append("userDate=@userDate"); strSql.Append(" where SmID=@SmID "); SqlParameter[] parameters = { new SqlParameter("@SmID", SqlDbType.Int,4), new SqlParameter("@SmX", SqlDbType.Float,8), new SqlParameter("@SmY", SqlDbType.Float,8), new SqlParameter("@UserID", SqlDbType.Int,4), new SqlParameter("@userDate", SqlDbType.DateTime)}; parameters[0].Value = model.SmID; parameters[1].Value = model.SmX; parameters[2].Value = model.SmY; parameters[3].Value = model.UserID; parameters[4].Value = model.userDate; try { DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return 0; } catch (Exception ex) { return 1; } }
/// <summary> /// 增加一条数据 /// </summary> public int AddCollieryGIS(TDTK.IndustryPlatform.SafetyMonitor.Model.GIS_Colliery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GIS_Colliery("); strSql.Append("SmX,SmY,CollieryID,UserID,userDate)"); strSql.Append(" values ("); strSql.Append("@SmX,@SmY,@CollieryID,@UserID,@userDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SmX", SqlDbType.Float,8), new SqlParameter("@SmY", SqlDbType.Float,8), new SqlParameter("@CollieryID", SqlDbType.VarChar,16), new SqlParameter("@UserID", SqlDbType.Int,4), new SqlParameter("@userDate", SqlDbType.DateTime)}; parameters[0].Value = model.SmX; parameters[1].Value = model.SmY; parameters[2].Value = model.CollieryID; parameters[3].Value = model.UserID; parameters[4].Value = model.userDate; object obj = DBUtility.DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 1; } else { return 0; } }
/// <summary> /// 存储过程执行添加空车过磅的操作 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddCarInfo(TDTK.IndustryPlatform.CoalTraffic.Model.TT_CarInfo model) { SqlParameter[] parameters = { new SqlParameter("@RoomCode", SqlDbType.VarChar,4), new SqlParameter("@EmptyWeight", SqlDbType.Decimal), new SqlParameter("@MostWeight", SqlDbType.Decimal), new SqlParameter("@CarNo", SqlDbType.NVarChar,20), new SqlParameter("@CarType", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerName", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerIDCard", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerPhone", SqlDbType.NVarChar,20), new SqlParameter("@RandomCode", SqlDbType.VarChar,4), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@BangType", SqlDbType.NVarChar,20), new SqlParameter("@FirstImage", SqlDbType.VarChar), new SqlParameter("@FileContent", SqlDbType.Image), new SqlParameter("@CarCode", SqlDbType.VarChar,20), new SqlParameter("@EmptyBangTime", SqlDbType.DateTime), new SqlParameter("@DriveLicense",SqlDbType.NVarChar,20), new SqlParameter("@DriverName",SqlDbType.NVarChar,20), new SqlParameter("@DriverIDCard",SqlDbType.NVarChar,20), new SqlParameter("@DriverPhone",SqlDbType.NVarChar,20) }; parameters[0].Value = model.RoomCode; parameters[1].Value = model.EmptyWeight; parameters[2].Value = model.MostWeight; parameters[3].Value = model.CarNo; parameters[4].Value = model.CarType; parameters[5].Value = model.CarOwnerName; parameters[6].Value = model.CarOwnerIDCard; parameters[7].Value = model.CarOwnerPhone; parameters[8].Value = model.RandomCode; parameters[9].Value = model.Operator; parameters[10].Value = model.BangType; parameters[11].Value = model.FirstImage; parameters[12].Value = model.FirstImageContent; parameters[13].Value = model.CarCode; parameters[14].Value = model.EmptyBangTime; parameters[15].Value = model.DriveLicense; parameters[16].Value = model.DriverName; parameters[17].Value = model.DriverIDCard; parameters[18].Value = model.DriverPhone; DataTable dt = DbHelperSQL.TRunProcedure("PT_CarInfo", parameters); if (dt != null) return dt.Rows[0][0].ToString(); else return ""; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_MessagePerson model) { List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_MessagePerson("); strSql.Append("MCode,TypeCode,MPName,PhoneNumber,ReceiveTypeCode,IsForBid)"); strSql.Append(" values ("); strSql.Append("@MCode,@TypeCode,@MPName,@PhoneNumber,@ReceiveTypeCode,@IsForBid)"); SqlParameter[] parameters = { new SqlParameter("@MCode", SqlDbType.VarChar,4), new SqlParameter("@TypeCode", SqlDbType.VarChar,1), new SqlParameter("@MPName", SqlDbType.NVarChar,20), new SqlParameter("@PhoneNumber", SqlDbType.VarChar,13), new SqlParameter("@ReceiveTypeCode", SqlDbType.VarChar,2), new SqlParameter("@IsForBid", SqlDbType.VarChar,1)}; parameters[0].Value = model.MCode; parameters[1].Value = model.TypeCode; parameters[2].Value = model.MPName; parameters[3].Value = model.PhoneNumber; parameters[4].Value = model.ReceiveTypeCode; parameters[5].Value = model.IsForBid; listSql.Add(strSql.ToString()); listParm.Add(parameters); if (System.Configuration.ConfigurationManager.AppSettings["IsAddLog"] == "1") { 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')"); SqlParameter[] parameters1 = { 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)}; parameters1[0].Value = "添加"; parameters1[1].Value = "TT_MessagePerson"; parameters1[2].Value = CookieManager.GetCookieValue("UserName"); parameters1[3].Value = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; parameters1[4].Value = model.MCode; parameters1[5].Value = ""; listSql.Add(strSql.ToString()); listParm.Add(parameters1); } return DbHelperSQL.ExecuteSqlCake(listSql, listParm) == true ? 1 : 0; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TDTK.PlatForm.MVC4.Model.TT_TaxItemDetail model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update TT_TaxItemDetail set "); strSql.Append("CoalKindCode=@CoalKindCode,"); strSql.Append("RoomCode=@RoomCode,"); strSql.Append("TaxItemCode=@TaxItemCode,"); strSql.Append("Amount=@Amount,"); strSql.Append("EffectTime=@EffectTime,"); strSql.Append("Operator=@Operator,"); strSql.Append("OperateTime=@OperateTime,"); strSql.Append("TaxGroup=@TaxGroup,"); strSql.Append("IsAssigned=@IsAssigned,"); strSql.Append("IsAll=@IsAll"); strSql.Append(" where ItemDetailId=@ItemDetailId"); SqlParameter[] parameters = { new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@TaxItemCode", SqlDbType.VarChar,10), new SqlParameter("@Amount", SqlDbType.Decimal,9), new SqlParameter("@EffectTime", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar,40), new SqlParameter("@OperateTime", SqlDbType.DateTime), new SqlParameter("@TaxGroup", SqlDbType.Decimal,9), new SqlParameter("@IsAssigned", SqlDbType.VarChar,1), new SqlParameter("@IsAll", SqlDbType.VarChar,1), new SqlParameter("@ItemDetailId", SqlDbType.BigInt,8)}; parameters[0].Value = model.CoalKindCode; parameters[1].Value = model.RoomCode; parameters[2].Value = model.TaxItemCode; parameters[3].Value = model.Amount; parameters[4].Value = model.EffectTime; parameters[5].Value = model.Operator; parameters[6].Value = model.OperateTime; parameters[7].Value = model.TaxGroup; parameters[8].Value = model.IsAssigned; parameters[9].Value = model.IsAll; parameters[10].Value = model.ItemDetailId; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public void Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_RemoteCard model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_RemoteCard("); strSql.Append("NavicertID,RemoteCode,RemoteState)"); strSql.Append(" values ("); strSql.Append("@NavicertID,@RemoteCode,@RemoteState)"); SqlParameter[] parameters = { new SqlParameter("@NavicertID", SqlDbType.VarChar,20), new SqlParameter("@RemoteCode", SqlDbType.VarChar,32), new SqlParameter("@RemoteState", SqlDbType.VarChar,1)}; parameters[0].Value = model.NavicertID; parameters[1].Value = model.RemoteCode; parameters[2].Value = model.RemoteState; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TDTK.IndustryPlatform.SafetyMonitor.Model.TN_FaultRecode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TN_FaultRecode("); strSql.Append("DevCode,DevName,DevType,DevAddress,DevUnit,MonitorLRV,MonitorURV,AlarmLRV,AlarmURV,TurnOffValue,TurnOnValue,DevState,LinkSenId,StartTime,EndTime,Duration,CoalCode)"); strSql.Append(" values ("); strSql.Append("@DevCode,@DevName,@DevType,@DevAddress,@DevUnit,@MonitorLRV,@MonitorURV,@AlarmLRV,@AlarmURV,@TurnOffValue,@TurnOnValue,@DevState,@LinkSenId,@StartTime,@EndTime,@Duration,@CoalCode)"); SqlParameter[] parameters = { //new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@DevCode", SqlDbType.VarChar,8), new SqlParameter("@DevName", SqlDbType.NVarChar,20), new SqlParameter("@DevType", SqlDbType.NVarChar,5), new SqlParameter("@DevAddress", SqlDbType.NVarChar,100), new SqlParameter("@DevUnit", SqlDbType.NVarChar,10), new SqlParameter("@MonitorLRV", SqlDbType.Decimal,5), new SqlParameter("@MonitorURV", SqlDbType.Decimal,5), new SqlParameter("@AlarmLRV", SqlDbType.Decimal,5), new SqlParameter("@AlarmURV", SqlDbType.Decimal,5), new SqlParameter("@TurnOffValue", SqlDbType.Decimal,5), new SqlParameter("@TurnOnValue", SqlDbType.Decimal,5), new SqlParameter("@DevState", SqlDbType.VarChar,4), new SqlParameter("@LinkSenId", SqlDbType.Char,10), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Duration", SqlDbType.Decimal,9), new SqlParameter("@CoalCode", SqlDbType.VarChar,20)}; //parameters[0].Value = model.Id; parameters[0].Value = model.DevCode; parameters[1].Value = model.DevName; parameters[2].Value = model.DevType; parameters[3].Value = model.DevAddress; parameters[4].Value = model.DevUnit; parameters[5].Value = model.MonitorLRV; parameters[6].Value = model.MonitorURV; parameters[7].Value = model.AlarmLRV; parameters[8].Value = model.AlarmURV; parameters[9].Value = model.TurnOffValue; parameters[10].Value = model.TurnOnValue; parameters[11].Value = model.DevState; parameters[12].Value = model.LinkSenId; parameters[13].Value = model.StartTime; parameters[14].Value = model.EndTime; parameters[15].Value = model.Duration; parameters[16].Value = model.CoalCode; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TDTK.PlatForm.MVC4.Model.TT_WaterBook model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_WaterBook("); strSql.Append("TradeCode,CollCode,JournalCode,StartMoney,TradeMoney,EndMoney,Operator,TradeDate,TradeKind,Remark,WeightCode,AuditUser,AuditDate)"); strSql.Append(" values ("); strSql.Append("@TradeCode,@CollCode,@JournalCode,@StartMoney,@TradeMoney,@EndMoney,@Operator,@TradeDate,@TradeKind,@Remark,@WeightCode,@AuditUser,@AuditDate)"); SqlParameter[] parameters = { new SqlParameter("@TradeCode", SqlDbType.VarChar,20), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@JournalCode", SqlDbType.Int,4), new SqlParameter("@StartMoney", SqlDbType.Decimal,9), new SqlParameter("@TradeMoney", SqlDbType.Decimal,9), new SqlParameter("@EndMoney", SqlDbType.Decimal,9), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@TradeDate", SqlDbType.DateTime), new SqlParameter("@TradeKind", SqlDbType.NVarChar,20), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@WeightCode", SqlDbType.VarChar,35), new SqlParameter("@AuditUser", SqlDbType.NVarChar,20), new SqlParameter("@AuditDate", SqlDbType.DateTime)}; parameters[0].Value = model.TradeCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.JournalCode; parameters[3].Value = model.StartMoney; parameters[4].Value = model.TradeMoney; parameters[5].Value = model.EndMoney; parameters[6].Value = model.Operator; parameters[7].Value = model.TradeDate; parameters[8].Value = model.TradeKind; parameters[9].Value = model.Remark; parameters[10].Value = model.WeightCode; parameters[11].Value = model.AuditUser; parameters[12].Value = model.AuditDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return rows; } else { return 0; } }
public static bool SetPostion(ModelList.Position p, TDTK.AppGis.Enum.SysEditType edit) { int intAdd; string strUpdate = "update TN_Position set XPoint=" + p.XPoint + " , YPoint=" + p.YPoint + " where KeyName='" + p.Key + "' and Belong='" + p.Belong + "'"; string strAdd = "insert into TN_Position(Belong,KeyName,XPoint,YPoint,Type,Layer,LockLayer) values('" + p.Belong + "','" + p.Key + "'," + p.XPoint + "," + p.YPoint + "," + (Int32)p.Type + "," + p.Layer + "," + Convert.ToInt32(p.LockLayer) + ")"; string strdel = "Delete TN_Position where KeyName='" + p.Key + "' and Belong='" + p.Belong + "'"; if (edit == TDTK.AppGis.Enum.SysEditType.新增) intAdd = DbHelperSQL.ExecuteSql(strAdd); else if (edit == TDTK.AppGis.Enum.SysEditType.修改) intAdd = DbHelperSQL.ExecuteSql(strUpdate); else intAdd = DbHelperSQL.ExecuteSql(strdel); if (intAdd == 0) return false; else return true; }
/// <summary> /// 添加新报警人员信息 /// </summary> /// <param name="reciver">报警人员Model</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Add(TDTK.IndustryPlatform.SafetyMonitor.Model.TN_NoteReciver reciver) { StringBuilder sb = new StringBuilder(); sb.Append("insert into TN_NoteReciver ("); sb.Append("CoalCode,"); sb.Append("CoalName,"); sb.Append("Duty,"); sb.Append("Department,"); sb.Append("Name,"); sb.Append("PhoneNo,"); sb.Append("Describe )"); sb.Append(" values ("); sb.Append("@CoalCode,"); sb.Append("@CoalName,"); sb.Append("@Duty,"); sb.Append("@Department,"); sb.Append("@Name,"); sb.Append("@PhoneNo,"); sb.Append("@Describe )"); SqlParameter[] param = { new SqlParameter("@CoalCode",SqlDbType.VarChar,20), new SqlParameter("@CoalName",SqlDbType.NVarChar,50), new SqlParameter("@Duty",SqlDbType.VarChar,20), new SqlParameter("@Department",SqlDbType.NVarChar,20), new SqlParameter("@Name",SqlDbType.NVarChar,20), new SqlParameter("@PhoneNo",SqlDbType.VarChar,20), new SqlParameter("@Describe",SqlDbType.VarChar,100) }; param[0].Value = reciver.CoalCode; param[1].Value = reciver.CoalName; param[2].Value = reciver.Duty; param[3].Value = reciver.Department; param[4].Value = reciver.Name; param[5].Value = reciver.PhoneNo; param[6].Value = reciver.Describe; int retVal = dal.ExecuteCommand(sb.ToString(), CommandType.Text, param); return retVal == 0 ? 0 : 1; }
/// <summary> /// 事务操作(准运卡) /// </summary> /// <param name="model"></param> /// <param name="tt_empty"></param> /// <returns></returns> public bool Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_Navicert model) { bool IsSucess; try { if (dal.Add(model)) { IsSucess = true; } else { IsSucess = false; } } catch (Exception ex) { throw new Exception(ex.Message); } return IsSucess; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_InitialCard model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TT_InitialCard("); strSql.Append("CardID,CardNO,CardType,InitialTime,IntialPerson)"); strSql.Append(" values ("); strSql.Append("@CardID,@CardNO,@CardType,@InitialTime,@IntialPerson)"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.VarChar,20), new SqlParameter("@CardNO", SqlDbType.VarChar,20), new SqlParameter("@CardType", SqlDbType.Char,1), new SqlParameter("@InitialTime", SqlDbType.DateTime), new SqlParameter("@IntialPerson", SqlDbType.NVarChar,50)}; parameters[0].Value = model.CardID; parameters[1].Value = model.CardNO; parameters[2].Value = model.CardType; parameters[3].Value = model.InitialTime; parameters[4].Value = model.IntialPerson; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_EmptyWeight model) { SqlParameter[] parameters = { new SqlParameter("@EmptyCode", SqlDbType.VarChar,20), new SqlParameter("@CarCode", SqlDbType.VarChar,20), new SqlParameter("@RemoteCardCode", SqlDbType.VarChar,20), new SqlParameter("@NavicertCode", SqlDbType.VarChar,20), new SqlParameter("@EmptyWeight", SqlDbType.Decimal,9), new SqlParameter("@BangType", SqlDbType.NVarChar,20), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@FrontImage", SqlDbType.VarChar), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@BangTime", SqlDbType.DateTime), new SqlParameter("@FrontImageContent", SqlDbType.Image)}; parameters[0].Value = model.EmptyCode; parameters[1].Value = model.CarCode; parameters[2].Value = model.RemoteCardCode; parameters[3].Value = model.NavicertCode; parameters[4].Value = model.EmptyWeight; parameters[5].Value = model.BangType; parameters[6].Value = model.RoomCode; parameters[7].Value = model.FrontImage; parameters[8].Value = model.Operator; parameters[9].Value = model.BangTime; parameters[10].Value = model.FrontImageContent; try { DataTable dt = DbHelperSQL.TRunProcedure("PT_EmptyWeight", parameters); if (dt != null) return dt.Rows[0][0].ToString(); else return ""; } catch { return ""; } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TDTK.IndustryPlatform.CoalTraffic.Model.Sys_OperateLog model) { 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,'s1000')"); SqlParameter[] parameters = { new SqlParameter("@LogType", SqlDbType.NVarChar,50), new SqlParameter("@OperateTable", SqlDbType.VarChar,50), new SqlParameter("@Operator", SqlDbType.NVarChar,50), new SqlParameter("@OperateIP", SqlDbType.VarChar,15), new SqlParameter("@RelationID", SqlDbType.VarChar,200), new SqlParameter("@Remark", SqlDbType.NVarChar,200)}; parameters[0].Value = model.LogType; parameters[1].Value = model.OperateTable; parameters[2].Value = model.Operator; parameters[3].Value = model.OperateIP; parameters[4].Value = model.RelationID; parameters[5].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TDTK.PlatForm.MVC4.Model.TT_TransferAccounts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TT_TransferAccounts set "); strSql.Append("FromCollCode=@FromCollCode,"); strSql.Append("ToCollCode=@ToCollCode,"); strSql.Append("TransferMoney=@TransferMoney,"); strSql.Append("Operator=@Operator,"); strSql.Append("OperateTime=@OperateTime,"); strSql.Append("OrgName=@OrgName"); strSql.Append(" where TransferID=@TransferID"); SqlParameter[] parameters = { new SqlParameter("@FromCollCode", SqlDbType.VarChar,10), new SqlParameter("@ToCollCode", SqlDbType.VarChar,10), new SqlParameter("@TransferMoney", SqlDbType.Decimal,9), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@OperateTime", SqlDbType.DateTime), new SqlParameter("@OrgName", SqlDbType.NVarChar,20), new SqlParameter("@TransferID", SqlDbType.BigInt,8)}; parameters[0].Value = model.FromCollCode; parameters[1].Value = model.ToCollCode; parameters[2].Value = model.TransferMoney; parameters[3].Value = model.Operator; parameters[4].Value = model.OperateTime; parameters[5].Value = model.OrgName; parameters[6].Value = model.TransferID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public int Add(TDTK.IndustryPlatform.CoalTraffic.Model.TT_MarkedCardSendRecord model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_MarkedCardSendRecord("); strSql.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)"); strSql.Append(" values ("); strSql.Append("@MarkedCardNo,@MarkedCardCode,@CollCode,@CoalKindCode,@SendCardDate,@Operator,@DepartName,@SendType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MarkedCardNo", SqlDbType.NVarChar,20), new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@SendCardDate", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@DepartName", SqlDbType.NVarChar,20), new SqlParameter("@SendType", SqlDbType.NVarChar,10)}; parameters[0].Value = model.MarkedCardNo; parameters[1].Value = model.MarkedCardCode; parameters[2].Value = model.CollCode; parameters[3].Value = model.CoalKindCode; parameters[4].Value = model.SendCardDate; parameters[5].Value = model.Operator; parameters[6].Value = model.DepartName; parameters[7].Value = model.SendType; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
void OnEnemyThrough(TDTK.UnitCreep u) { playInfo.lives--; game.OnEnemyThrough(u); if (playInfo.lives <= 0) { GameOver(); } gameUI.UpdateScreen(); }
void OnEnemyDestroyed(TDTK.Unit u) { if (u is TDTK.UnitCreep) { playInfo.kills++; } // u.transform.position; GameObject o = ObjectPoolManager.Spawn(coinSource); //Instantiate(coinSource) as GameObject; o.transform.position = u.transform.position; o.SetActive(true); gameUI.UpdateScreen(); }