コード例 #1
0
 public static void UpdateMenuInfor(string string_0, string string_1, string string_2, bool bool_0)
 {
     string str = "";
     SqlDataAccess access = new SqlDataAccess();
     str = "delete from GpsJTBMsgHistory where SimNum='" + string_0 + "' and MsgType=" + string_1 + " and MsgID=" + string_2;
     access.DeleteBySql(str);
     if (bool_0)
     {
         str = " insert into GpsJTBMsgHistory(SimNum,MsgType,MsgID,CreateDate) values('" + string_0 + "'," + string_1 + "," + string_2 + ",getdate())";
         access.insertBySql(str);
     }
 }
コード例 #2
0
 public static int InsertCommandParameterToDB(string string_0, int int_0, int int_1, string string_1)
 {
     string format = "insert into GPSJTBSysSndCmd(SimNum,CmdCode,CmdContent,OrderId,AddTime,bSend) values('{0}', {1}, '{2}',{3}, getdate(),-1)";
     string str2 = string.Format(format, new object[] { string_0, int_1, string_1, int_0 });
     SqlDataAccess access = new SqlDataAccess();
     return access.insertBySql(str2);
 }