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