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)); }