public int Update(EnvironmentTabM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EnvironmentTab set ");
strSql.Append("loginName=@loginName,");
strSql.Append("EnvironmentTypeid=@EnvironmentTypeid,");
strSql.Append("Chineseintroduced=@Chineseintroduced,");
strSql.Append("Englishintroduction=@Englishintroduction,");
strSql.Append("createtime=@createtime,");
strSql.Append("updatetime=@updatetime");
strSql.Append(" where Environmentid=@Environmentid ");
SqlParameter[] parameters =
{
new SqlParameter("@Environmentid", SqlDbType.Int, 4),
new SqlParameter("@loginName", SqlDbType.NVarChar, 200),
new SqlParameter("@EnvironmentTypeid", SqlDbType.Int, 4),
new SqlParameter("@Chineseintroduced", SqlDbType.Text),
new SqlParameter("@Englishintroduction", SqlDbType.Text),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@updatetime", SqlDbType.DateTime)
};
parameters[0].Value = model.Environmentid;
parameters[1].Value = model.loginName;
parameters[2].Value = model.EnvironmentTypeid;
parameters[3].Value = model.Chineseintroduced;
parameters[4].Value = model.Englishintroduction;
parameters[5].Value = model.Createtime;
parameters[6].Value = model.Updatetime;
return(DBHelper.ExecuteSql(strSql.ToString(), parameters));
}
public EnvironmentTabM EnvironmentlistByLoginNameandTypeid(string loginname, int environmentid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Environmentid,loginName,EnvironmentTypeid,Chineseintroduced,Englishintroduction,createtime,updatetime from EnvironmentTab ");
strSql.Append(" where EnvironmentTypeid=@EnvironmentTypeid and loginName=@loginName ");
SqlParameter[] parameters =
{
new SqlParameter("@EnvironmentTypeid", SqlDbType.Int, 4),
new SqlParameter("@loginName", SqlDbType.NVarChar, 200)
};
parameters[0].Value = environmentid;
parameters[1].Value = loginname;
EnvironmentTabM model = new EnvironmentTabM();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Environmentid"].ToString() != "")
{
model.Environmentid = int.Parse(ds.Tables[0].Rows[0]["Environmentid"].ToString());
}
model.loginName = ds.Tables[0].Rows[0]["loginName"].ToString();
if (ds.Tables[0].Rows[0]["EnvironmentTypeid"].ToString() != "")
{
model.EnvironmentTypeid = int.Parse(ds.Tables[0].Rows[0]["EnvironmentTypeid"].ToString());
}
model.Chineseintroduced = ds.Tables[0].Rows[0]["Chineseintroduced"].ToString();
model.Englishintroduction = ds.Tables[0].Rows[0]["Englishintroduction"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.Createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
}
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.Updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
}
return(model);
}
else
{
return(null);
}
}
public GZS.Model.EnvironmentTabM GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Environmentid,loginName,EnvironmentTypeid,Chineseintroduced,Englishintroduction,createtime,updatetime from EnvironmentTab ");
strSql.Append(" where Environmentid=@Environmentid ");
SqlParameter[] parameters =
{
new SqlParameter("@Environmentid", SqlDbType.Int, 4)
};
parameters[0].Value = id;
EnvironmentTabM model = new EnvironmentTabM();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Environmentid"].ToString() != "")
{
model.Environmentid = int.Parse(ds.Tables[0].Rows[0]["Environmentid"].ToString());
}
model.loginName = ds.Tables[0].Rows[0]["loginName"].ToString();
if (ds.Tables[0].Rows[0]["EnvironmentTypeid"].ToString() != "")
{
model.EnvironmentTypeid = int.Parse(ds.Tables[0].Rows[0]["EnvironmentTypeid"].ToString());
}
model.Chineseintroduced = ds.Tables[0].Rows[0]["Chineseintroduced"].ToString();
model.Englishintroduction = ds.Tables[0].Rows[0]["Englishintroduction"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.Createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
}
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.Updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
}
return(model);
}
else
{
return(null);
}
}
public int Update(EnvironmentTabM model)
{
return(dal.Update(model));
}
