예제 #1
0
 public int Add(Station model)
 {
     StringBuilder stringBuilder = new StringBuilder();
     stringBuilder.Append("insert into GpsStation(");
     stringBuilder.Append("RegionDot,RegionName,RegionType,StationType)");
     stringBuilder.Append(" values (");
     stringBuilder.Append("@RegionDot,@RegionName,@RegionType,@StationType)");
     stringBuilder.Append(";select @@IDENTITY");
     string str = stringBuilder.ToString();
     List<SqlParam> sqlParams = new List<SqlParam>();
     SqlParam sqlParam = new SqlParam()
     {
         name = "RegionDot",
         @value = model.RegionDot
     };
     sqlParams.Add(sqlParam);
     SqlParam sqlParam1 = new SqlParam()
     {
         name = "RegionName",
         @value = model.RegionName
     };
     sqlParams.Add(sqlParam1);
     SqlParam sqlParam2 = new SqlParam()
     {
         name = "RegionType",
         @value = model.RegionType
     };
     sqlParams.Add(sqlParam2);
     SqlParam sqlParam3 = new SqlParam()
     {
         name = "StationType",
         @value = model.StationType
     };
     sqlParams.Add(sqlParam3);
     DataTable dataTable = RemotingClient.ExecParamSqlByCompress(str, sqlParams);
     if (dataTable != null && dataTable.Rows.Count > 0)
     {
         return 1;
     }
     return 0;
 }
예제 #2
0
 public bool Update(Station model)
 {
     StringBuilder stringBuilder = new StringBuilder();
     stringBuilder.Append("update GpsStation set ");
     stringBuilder.Append("RegionDot=@RegionDot,");
     stringBuilder.Append("RegionName=@RegionName,");
     stringBuilder.Append("RegionType=@RegionType,");
     stringBuilder.Append("UpdateTime=@UpdateTime,");
     stringBuilder.Append("StationType=@StationType");
     stringBuilder.Append(" where ID=@ID");
     string str = stringBuilder.ToString();
     List<SqlParam> sqlParams = new List<SqlParam>();
     SqlParam sqlParam = new SqlParam()
     {
         name = "RegionDot",
         @value = model.RegionDot
     };
     sqlParams.Add(sqlParam);
     SqlParam sqlParam1 = new SqlParam()
     {
         name = "RegionName",
         @value = model.RegionName
     };
     sqlParams.Add(sqlParam1);
     SqlParam sqlParam2 = new SqlParam()
     {
         name = "RegionType",
         @value = model.RegionType
     };
     sqlParams.Add(sqlParam2);
     SqlParam sqlParam3 = new SqlParam()
     {
         name = "UpdateTime",
         @value = model.UpdateTime
     };
     sqlParams.Add(sqlParam3);
     SqlParam sqlParam4 = new SqlParam()
     {
         name = "StationType",
         @value = model.StationType
     };
     sqlParams.Add(sqlParam4);
     SqlParam sqlParam5 = new SqlParam()
     {
         name = "ID",
         @value = model.ID
     };
     sqlParams.Add(sqlParam5);
     if (RemotingClient.ExecParamNoQuery(str, sqlParams).ResultCode == (long)0)
     {
         return true;
     }
     return false;
 }
예제 #3
0
 public bool Delete(int ID)
 {
     StringBuilder stringBuilder = new StringBuilder();
     stringBuilder.Append("delete from GpsStation ");
     stringBuilder.Append(" where ID=@ID");
     string str = stringBuilder.ToString();
     List<SqlParam> sqlParams = new List<SqlParam>();
     SqlParam sqlParam = new SqlParam()
     {
         name = "ID",
         @value = ID
     };
     sqlParams.Add(sqlParam);
     if (RemotingClient.ExecParamNoQuery(str, sqlParams).ResultCode == (long)0)
     {
         return true;
     }
     return false;
 }