private void button1BigAreaSchemeOK_Click(object sender, EventArgs e)
{
CoScheduling.Core.Model.BIGAREA_SCHEME model = new CoScheduling.Core.Model.BIGAREA_SCHEME();
CoScheduling.Core.DAL.BIGAREA_SCHEME dal = new CoScheduling.Core.DAL.BIGAREA_SCHEME();
if (!String.IsNullOrEmpty(this.textBoxBigAreaSchemeName.Text) && (this.dateTimePickerBigAreaSchemeEndTime.Value > this.dateTimePickerBigAreaSchemeStartTime.Value))
{
model.SCHEMENAME = this.textBoxBigAreaSchemeName.Text;
model.SCHEMEBTIME = this.dateTimePickerBigAreaSchemeStartTime.Value;
model.SCHEMEETIME = this.dateTimePickerBigAreaSchemeEndTime.Value;
try
{
dal.Add(model);
schemeid = dal.GetLatestSchemeid();
this.DialogResult = DialogResult.OK;
}
catch (System.Exception ex)
{
MessageBox.Show("方案添加失败，请检查数据连接！");
}
}
else
{
MessageBox.Show("请填写有效信息！");
}
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private CoScheduling.Core.Model.BIGAREA_SCHEME GetModel(DbDataReader dr)
{
CoScheduling.Core.Model.BIGAREA_SCHEME model = new CoScheduling.Core.Model.BIGAREA_SCHEME();
model.SCHEMEID = Convert.ToInt32(dr["SCHEMEID"]);
model.SCHEMENAME = Convert.ToString(dr["SCHEMENAME"]);
model.SCHEMEBTIME = Convert.ToDateTime(dr["SCHEMEBTIME"]);
model.SCHEMEETIME = Convert.ToDateTime(dr["SCHEMEETIME"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CoScheduling.Core.Model.BIGAREA_SCHEME GetModel(decimal SCHEMEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BIGAREA_SCHEME ");
strSql.Append(" WHERE SCHEMEID=" + SCHEMEID);
CoScheduling.Core.Model.BIGAREA_SCHEME model = new CoScheduling.Core.Model.BIGAREA_SCHEME();
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CoScheduling.Core.Model.BIGAREA_SCHEME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO BIGAREA_SCHEME(");
strSql.Append("SCHEMENAME,SCHEMEBTIME,SCHEMEETIME)");
strSql.Append(" VALUES (");
strSql.Append("@in_SCHEMENAME,@in_SCHEMEBTIME,@in_SCHEMEETIME)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SCHEMENAME", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEBTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEETIME", SqlDbType.DateTime)
};
cmdParms[0].Value = model.SCHEMENAME;
cmdParms[1].Value = model.SCHEMEBTIME;
cmdParms[2].Value = model.SCHEMEETIME;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(CoScheduling.Core.Model.BIGAREA_SCHEME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE BIGAREA_SCHEME SET ");
strSql.Append("SCHEMENAME=@in_SCHEMENAME,");
strSql.Append("SCHEMEBTIME=@in_SCHEMEBTIME,");
strSql.Append("SCHEMEETIME=@in_SCHEMEETIME");
strSql.Append(" WHERE SCHEMEID=@in_SCHEMEID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SCHEMENAME", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEBTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEETIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SCHEMENAME;
cmdParms[1].Value = model.SCHEMEBTIME;
cmdParms[2].Value = model.SCHEMEETIME;
cmdParms[3].Value = model.SCHEMEID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
