private void schedulerControl1_SelectionChanged(object sender, EventArgs e)
{
DateTime _dt = this.schedulerControl1.SelectedInterval.Start;
this.te_RQ.EditValue = _dt.ToString("yyyy年MM月dd日");
if (DateList != null)
{
var _find = from _c in DateList
where _c.GZ_Date == _dt
select _c;
if (_find != null && _find.Count() > 0)
{
WC_DataInfo _dc = _find.First();
this.te_IsWorkDay.Checked = _dc.IsWorkDay;
this.te_IsFXSBR.Checked = _dc.IsFXSBR;
this.te_IsTJSBR.Checked = _dc.IsTJSBR;
this.te_Des.EditValue = _dc.Meta;
}
else
{
this.te_IsWorkDay.Checked = CheckDateIsWorkDay(_dt);
this.te_IsFXSBR.Checked = false;
this.te_IsTJSBR.Checked = (_dt.Day == TJSB_Setting.SBDay);
this.te_Des.EditValue = "";
}
}
else
{
this.te_IsWorkDay.Checked = CheckDateIsWorkDay(_dt);
this.te_IsFXSBR.Checked = false;
this.te_IsTJSBR.Checked = false;
this.te_Des.EditValue = "";
}
}
public bool SaveDataInfo(WC_DataInfo DataInfo)
{
using (OracleConnection cn = OracleHelper.OpenConnection())
{
OracleTransaction _txn = cn.BeginTransaction();
try
{
OracleCommand _cmd = new OracleCommand(SQL_DelDataInfo, cn);
_cmd.Parameters.Add(":GZDATE", DataInfo.GZ_Date.ToString("yyyyMMdd"));
_cmd.ExecuteNonQuery();
OracleCommand _cmd2 = new OracleCommand(SQL_InsDataInfo, cn);
_cmd2.Parameters.Add(":GZDATA", DataInfo.GZ_Date.ToString("yyyyMMdd"));
_cmd2.Parameters.Add(":GZ_META", DataInfo.Meta);
_cmd2.Parameters.Add(":GZ_YEAR", Convert.ToDecimal(DataInfo.GZ_Date.Year));
_cmd2.Parameters.Add(":GZ_MONTH", Convert.ToDecimal(DataInfo.GZ_Date.Month));
_cmd2.Parameters.Add(":GZ_DAY", Convert.ToDecimal(DataInfo.GZ_Date.Day));
_cmd2.Parameters.Add(":GZ_LX", DataInfo.IsTJSBR ? (decimal)1 : (decimal)0);
_cmd2.Parameters.Add(":GZ_SFGZR", DataInfo.IsWorkDay ? (decimal)0 : (decimal)1);
_cmd2.Parameters.Add(":GZ_FXSB", DataInfo.IsFXSBR ? (decimal)1 : (decimal)0);
_cmd2.ExecuteNonQuery();
_txn.Commit();
return(true);
}
catch (Exception ex)
{
string _err = string.Format("写入GZRL日期:{0}时发生错误:{1}", DataInfo.GZ_Date, ex.Message);
OralceLogWriter.WriteSystemLog(_err, "ERROR");
_txn.Rollback();
return(false);
}
}
}
public List <WC_DataInfo> GetDataInfo(int Year)
{
List <WC_DataInfo> _ret = new List <WC_DataInfo>();
OracleParameter[] _param =
{
new OracleParameter(":STARTDATE", OracleDbType.Varchar2, 8),
new OracleParameter(":ENDDATE", OracleDbType.Varchar2, 8)
};
_param[0].Value = (new DateTime(Year - 1, 12, 1)).ToString("yyyyMMdd");
_param[1].Value = (new DateTime(Year + 1, 1, 31)).ToString("yyyyMMdd");
OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text,
SQL_GetDataInfo, _param);
while (dr.Read())
{
string _datestr = dr.IsDBNull(0) ? "" : dr.GetString(0);
if (_datestr != "" && _datestr.Length == 8)
{
WC_DataInfo _di = new WC_DataInfo();
_di.GZ_Date = new DateTime(int.Parse(_datestr.Substring(0, 4)), int.Parse(_datestr.Substring(4, 2)), int.Parse(_datestr.Substring(6, 2)));
_di.Meta = dr.IsDBNull(1) ? "" : dr.GetString(1);
_di.Year = int.Parse(dr.IsDBNull(2) ? "1" : dr.GetString(2));
_di.Month = int.Parse(dr.IsDBNull(3) ? "1" : dr.GetString(3));
_di.Day = int.Parse(dr.IsDBNull(4) ? "1" : dr.GetString(4));
_di.IsTJSBR = ((dr.IsDBNull(5) ? 0 : Convert.ToInt16(dr.GetDecimal(5))) > 0);
_di.IsWorkDay = ((dr.IsDBNull(6) ? 0 : Convert.ToInt16(dr.GetDecimal(6))) < 1);
_di.IsFXSBR = ((dr.IsDBNull(7) ? 0 : Convert.ToInt16(dr.GetDecimal(7))) > 0);
_ret.Add(_di);
}
}
dr.Close();
return(_ret);
}
public bool SaveDataInfo(WC_DataInfo DataInfo)
{
try
{
OraSysManagerFactroy _of = new OraSysManagerFactroy();
return(_of.SaveDataInfo(DataInfo));
}
catch (Exception ex)
{
string _error = string.Format("保存工作日历的日期设置时发生错误！{0}", ex.Message);
//SystemLogWriter.WriteLog(_error, System.Diagnostics.EventLogEntryType.Error);
return(false);
}
}
private void SaveSetting()
{
if (this.te_RQ.EditValue == null)
{
return;
}
string _dt = this.te_RQ.EditValue.ToString();
WC_DataInfo _info = new WC_DataInfo();
_info.GZ_Date = new DateTime(int.Parse(_dt.Substring(0, 4)), int.Parse(_dt.Substring(5, 2)), int.Parse(_dt.Substring(8, 2)));
_info.Year = _info.GZ_Date.Year;
_info.Month = _info.GZ_Date.Month;
_info.Day = _info.GZ_Date.Day;
_info.IsWorkDay = this.te_IsWorkDay.Checked;
_info.IsTJSBR = this.te_IsTJSBR.Checked;
_info.IsFXSBR = this.te_IsFXSBR.Checked;
_info.Meta = (this.te_Des.EditValue == null) ? "" : this.te_Des.EditValue.ToString();
using (CommonServiceClient _csc = new CommonServiceClient())
{
if (_csc.SaveDataInfo(_info))
{
var find = from _c in DateList
where _c.GZ_Date == _info.GZ_Date
select _c;
if (find == null || find.Count() < 1)
{
this.DateList.Add(_info);
}
else
{
WC_DataInfo _wc = find.First();
_wc.IsWorkDay = _info.IsWorkDay;
_wc.IsFXSBR = _info.IsFXSBR;
_wc.IsTJSBR = _info.IsTJSBR;
_wc.Meta = _info.Meta;
}
int _year = int.Parse(this.TE_YEAR.Text);
DrawDates(_year);
}
}
}
private bool CheckDateIsWorkDay(DateTime _dt)
{
if (DateList != null)
{
var _find = from _c in DateList
where _c.GZ_Date == _dt
select _c;
if (_find != null && _find.Count() > 0)
{
WC_DataInfo _dc = _find.First();
return(_dc.IsWorkDay);
}
else
{
return(_dt.DayOfWeek != DayOfWeek.Sunday && _dt.DayOfWeek != DayOfWeek.Saturday);
}
}
else
{
return(_dt.DayOfWeek != DayOfWeek.Sunday && _dt.DayOfWeek != DayOfWeek.Saturday);
}
}
