/// <summary>
/// 添加人员
/// </summary>
/// <returns></returns>
public InterfaceRet Add(string data)
{
RsTM tm = Newtonsoft.Json.JsonConvert.DeserializeObject <RsTM>(data);
dbAccess.Add(tm);
return(_ret);
}
public RsTM Get(string id)
{
string sql = "select * from TAB_Org_Trainman where strTrainmanGUID = @TrainmanGUID";
SqlParameter[] sqlparams =
{
new SqlParameter("TrainmanGUID", id)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlparams).Tables[0];
if (dt.Rows.Count > 0)
{
RsTM tm = new RsTM();
tm.ID = dt.Rows[0]["strTrainmanGUID"].ToString();
tm.Number = dt.Rows[0]["strTrainmanNumber"].ToString();
tm.Name = dt.Rows[0]["strTrainmanName"].ToString();
tm.Tel = dt.Rows[0]["strTelNumber"].ToString();
tm.Jl = dt.Rows[0]["strTrainmanJiaoluGUID"].ToString();
return(tm);
}
else
{
return(null);
}
}
public void Update(RsTM tm)
{
string sql = @"update TAB_Org_Trainman set strTrainmanNumber = @tmNumber,strTrainmanName = @tmName,
strTelNumber = @telNumber,strTrainmanJiaoluGUID = @jlGUID where strTrainmanGUID = @tmGUID";
SqlParameter[] sqlparams =
{
new SqlParameter("tmGUID", tm.ID),
new SqlParameter("tmNumber", tm.Number),
new SqlParameter("tmName", tm.Name),
new SqlParameter("telNumber", tm.Tel),
new SqlParameter("jlGUID", tm.Jl),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, sqlparams);
notifyer.NotifyChange(Identifyer, tm.ID, ChangeType.ctUpdate);
}
public void Add(RsTM tm)
{
string sql = @"insert into TAB_Org_Trainman (strTrainmanGUID,strTrainmanNumber,strTrainmanName,
strTelNumber,strTrainmanJiaoluGUID) values(@tmGUID,@tmNumber,@tmName,@telNumber,@jlGUID)";
SqlParameter[] sqlparams =
{
new SqlParameter("tmGUID", tm.ID),
new SqlParameter("tmNumber", tm.Number),
new SqlParameter("tmName", tm.Name),
new SqlParameter("telNumber", tm.Tel),
new SqlParameter("jlGUID", tm.Jl),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, sqlparams);
notifyer.NotifyChange(Identifyer, tm.ID, ChangeType.ctAdd);
}
public List <RsTM> GetAll()
{
List <RsTM> _ret = new List <RsTM>();
string sql = "select strTrainmanGUID,strTrainmanNumber,strTrainmanName,strTelNumber,strTrainmanJiaoLuGUID from TAB_Org_Trainman";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
RsTM tm = new RsTM();
tm.ID = dr["strTrainmanGUID"].ToString();
tm.Number = dr["strTrainmanNumber"].ToString();
tm.Name = dr["strTrainmanName"].ToString();
tm.Tel = dr["strTelNumber"].ToString();
tm.Jl = dr["strTrainmanJiaoluGUID"].ToString();
_ret.Add(tm);
}
return(_ret);
}
