AdvertManage.Model.AMS_SchoolModel DataRowToAms_SchoolModel(DataRow dr)
{
AdvertManage.Model.AMS_SchoolModel model = new AdvertManage.Model.AMS_SchoolModel();
if (dr["Id"] != null && dr["Id"].ToString() != "")
{
model.Id = int.Parse(dr["Id"].ToString());
}
if (dr["Number"] != null && dr["Number"].ToString() != "")
{
model.Number = dr["Number"].ToString();
}
if (dr["Name"] != null && dr["Name"].ToString() != "")
{
model.Name = dr["Name"].ToString();
}
if (dr["DTUip"] != null && dr["DTUip"].ToString() != "")
{
model.DTUip = dr["DTUip"].ToString();
}
if (dr["Describe"] != null && dr["Describe"].ToString() != "")
{
model.Describe = dr["Describe"].ToString();
}
if (dr["ConnectionString"] != null && dr["ConnectionString"].ToString() != "")
{
model.ConnectionString = dr["ConnectionString"].ToString();
}
if (dr["Flag"] != null && dr["Flag"].ToString() != "")
{
model.Flag = int.Parse(dr["Flag"].ToString());
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AdvertManage.Model.AMS_SchoolModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_School(");
strSql.Append("Number,Name,DTUip,Describe,ConnectionString,Flag)");
strSql.Append(" values (");
strSql.Append("@Number,@Name,@DTUip,@Describe,@ConnectionString,@Flag)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@Name", SqlDbType.NVarChar, 30),
new SqlParameter("@DTUip", SqlDbType.NVarChar, 20),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200),
new SqlParameter("@ConnectionString", SqlDbType.NVarChar, 200),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.Name;
parameters[2].Value = model.DTUip;
parameters[3].Value = model.Describe;
parameters[4].Value = model.ConnectionString;
parameters[5].Value = model.Flag;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void button8_Click(object sender, RoutedEventArgs e)
{
CommandTypeItem cmdType = comboBox_SelectType.SelectedItem as CommandTypeItem;
CommandHandleResultItem result = comboBox3.SelectedItem as CommandHandleResultItem;
AdvertManage.Model.AMS_SchoolModel school = cbxSchool.SelectedItem as AdvertManage.Model.AMS_SchoolModel;
ViewModel.BindCommandModel(school.Id, cmdType.TypeItem, result.HandleResult);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AdvertManage.Model.AMS_SchoolModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_School set ");
strSql.Append("Number=@Number,");
strSql.Append("Name=@Name,");
strSql.Append("DTUip=@DTUip,");
strSql.Append("Describe=@Describe,");
strSql.Append("ConnectionString=@ConnectionString,");
strSql.Append("Flag=@Flag");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Number", SqlDbType.NVarChar, 50),
new SqlParameter("@Name", SqlDbType.NVarChar, 30),
new SqlParameter("@DTUip", SqlDbType.NVarChar, 20),
new SqlParameter("@Describe", SqlDbType.NVarChar, 200),
new SqlParameter("@ConnectionString", SqlDbType.NVarChar, 200),
new SqlParameter("@Flag", SqlDbType.Int),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Number;
parameters[1].Value = model.Name;
parameters[2].Value = model.DTUip;
parameters[3].Value = model.Describe;
parameters[4].Value = model.ConnectionString;
parameters[5].Value = model.Flag;
parameters[6].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
