/// <summary>
/// 添加站点配置信息
/// </summary>
/// <param name="msr"></param>
/// <param name="selectID"></param>
/// <returns></returns>
public bool addStationInfoWithSetting(Model.StationRelation msr, out int selectID)
{
SqlParameter outpara = new SqlParameter("@selid", SqlDbType.Int, 4);
outpara.Direction = ParameterDirection.Output;
SqlParameter[] paras =
{
new SqlParameter("@cpid", msr.CP_ID),
new SqlParameter("@staid", msr.StationID),
new SqlParameter("@staname", msr.StationName),
outpara
};
int retval = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "sp_addStationInfoWithSetting", paras);
selectID = Convert.ToInt32(outpara.Value);
return(retval > 0);
}
public Model.StationRelation[] getStations(string userID, Model.StationRelation msr)
{
return(userID == null?ddal.getStations(msr) : ddal.getStations(userID, msr));
}
public Model.StationRelation searchStationInfo2(Model.StationRelation msr)
{
return(ddal.searchStationInfo2(msr));
}
public Model.StationRelation insertStationsInfoReturnID(Model.StationRelation msr)//insert
{
/*
* int flag = 1;//0表示操作成功，1表示操作失败
*
* SqlCommand CustomerComm;
* SqlParameter par0;
* SqlParameter par1;
*
*
*
* CustomerComm = new SqlCommand("insertStationInfoReturnID", con);
* CustomerComm.CommandType = CommandType.StoredProcedure;
*
* par0 = new SqlParameter("@station_id", msr.StationID);
* par1 = new SqlParameter("@station_name", msr.StationName);
*
* CustomerComm.Parameters.Add(par0);
* CustomerComm.Parameters.Add(par1);
*
*
* int done;
* string result = "";
*
* try
* {
* con.Open();
* done = CustomerComm.ExecuteNonQuery();
* flag = 0;
* }
* catch (Exception ex)
* {
* result = ex.ToString();
* }
* finally
* {
* con.Close();
* }
*
* return flag;
*
*/
SqlDataAdapter da = new SqlDataAdapter("insertStationInfoReturnID", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter par0;
SqlParameter par1;
par0 = new SqlParameter("@station_id", msr.StationID);
par1 = new SqlParameter("@station_name", msr.StationName);
da.SelectCommand.Parameters.Add(par0);
da.SelectCommand.Parameters.Add(par1);
DataSet ds = new DataSet();
string result = "";
try
{
con.Open();
da.Fill(ds);
}
catch (Exception ex)
{
result = ex.ToString();
}
finally
{
con.Close();
}
Model.StationRelation msrback = new Model.StationRelation();
if (result == "")
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
msrback.SelectID = getInt(dt.Rows[0]["id"].ToString());
msrback.StationTableID = getInt(dt.Rows[0]["id"].ToString());
}
else
{
return(null);
}
return(msrback);
}
public int setStationsInfo(Model.StationRelation msr, string command) //insert\update\delete
{
int flag = 1; //0表示操作成功，1表示操作失败
SqlCommand CustomerComm;
SqlParameter par0;
SqlParameter par1;
SqlParameter par2;
switch (command)
{
case "update":
CustomerComm = new SqlCommand("updateStationInfo", con);
CustomerComm.CommandType = CommandType.StoredProcedure;
par0 = new SqlParameter("@station_id", msr.StationID);
par1 = new SqlParameter("@station_name", msr.StationName);
par2 = new SqlParameter("@id", msr.StationTableID);
CustomerComm.Parameters.Add(par0);
CustomerComm.Parameters.Add(par1);
CustomerComm.Parameters.Add(par2);
break;
case "delete":
CustomerComm = new SqlCommand("deleteStationInfo", con);
CustomerComm.CommandType = CommandType.StoredProcedure;
par2 = new SqlParameter("@id", msr.StationTableID);
CustomerComm.Parameters.Add(par2);
break;
default: //insert
CustomerComm = new SqlCommand("insertStationInfo", con);
CustomerComm.CommandType = CommandType.StoredProcedure;
par0 = new SqlParameter("@station_id", msr.StationID);
par1 = new SqlParameter("@station_name", msr.StationName);
CustomerComm.Parameters.Add(par0);
CustomerComm.Parameters.Add(par1);
break;
}
int done;
string result = "";
try
{
con.Open();
done = CustomerComm.ExecuteNonQuery();
flag = 0;
}
catch (Exception ex)
{
result = ex.ToString();
}
finally
{
con.Close();
}
return(flag);
}
public bool addStationInfoWithSetting(Model.StationRelation msr, out int selectID)
{
return(sdal.addStationInfoWithSetting(msr, out selectID));
}
public Model.StationRelation insertStationsInfoReturnID(Model.StationRelation msr)
{
return(sdal.insertStationsInfoReturnID(msr));
}
public int setStationsInfo(Model.StationRelation msr, string command)
{
return(sdal.setStationsInfo(msr, command));
}