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