public void Update(DD_InforMation inforMation)
{
string sql = @" UPDATE DD_InforMation SET
DD_BMNum = @DD_BMNum
, DD_KFNume = @DD_KFNume
, DD_RQTime = @DD_RQTime
, DD_QRTime = @DD_QRTime
, DD_ZDTime = @DD_ZDTime
, DD_SDTime = @DD_SDTime
, DD_HSTime = @DD_HSTime
, DD_ReseTime = @DD_ReseTime
Where AutoID=@AutoID";
SqlHelper.ExecuteNonQuery(sql,
new SqlParameter("@DD_BMNum", inforMation.DD_BMNum),
new SqlParameter("@DD_KFNume", inforMation.DD_KFNume),
new SqlParameter("@DD_RQTime", inforMation.DD_RQTime),
new SqlParameter("@DD_QRTime", inforMation.DD_QRTime),
new SqlParameter("@DD_ZDTime", SqlHelper.ToDBnullValue(inforMation.DD_ZDTime)),
new SqlParameter("@DD_SDTime", inforMation.DD_SDTime),
new SqlParameter("@DD_HSTime", inforMation.DD_HSTime),
new SqlParameter("@DD_ReseTime", inforMation.DD_ReseTime),
new SqlParameter("@AutoID", inforMation.AutoID)
);
}
public DD_InforMation dD_information(string dtime)
{
string sql = "select * from DD_InforMation where DD_RQTime=@DD_RQTime";
DataTable data = SqlHelper.ExecuteTable(sql, new SqlParameter("@DD_RQTime", dtime));
DD_InforMation dD_Infor = null;
if (data.Rows.Count > 0)
{
dD_Infor = RowToDDInforMation(data.Rows[0]);
}
return(dD_Infor);
}
public List <DD_InforMation> GetAlldD_Infors()
{
string sql = "select * from DD_InforMation where DD_SDTime IS NOT NULL";
DataTable dt = SqlHelper.ExecuteTable(sql);
List <DD_InforMation> list = new List <DD_InforMation>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
DD_InforMation inforMation = RowToDDInforMationID(item);
list.Add(inforMation);
}
}
return(list);
}
private DD_InforMation RowToDDInforMation(DataRow dr)
{
DD_InforMation dD_Infor = new DD_InforMation()
{
DD_BMNum = dr["DD_BMNum"].ToString(),
DD_KFNume = dr["DD_KFNume"].ToString(),
DD_RQTime = Convert.ToDateTime(dr["DD_RQTime"]),
DD_QRTime = Convert.ToDateTime(dr["DD_QRTime"]),
DD_SDTime = Convert.ToDateTime(dr["DD_SDTime"]),
DD_ReseTime = Convert.ToDateTime(dr["DD_ReseTime"]),
DD_HSTime = dr["DD_HSTime"].ToString(),
DD_ZDTime = Convert.ToDateTime(dr["DD_BMNum"])
};
return(dD_Infor);
}
private DD_InforMation RowToDDInforMationID(DataRow dr)
{
DD_InforMation dD_Infor = new DD_InforMation()
{
AutoID = Convert.ToInt32(dr["AutoID"]),
DD_BMNum = dr["DD_BMNum"].ToString(),
DD_KFNume = dr["DD_KFNume"].ToString(),
DD_RQTime = (DateTime?)SqlHelper.GetDBnullValue(dr["DD_RQTime"]),
DD_QRTime = (DateTime?)SqlHelper.GetDBnullValue(dr["DD_QRTime"]),
DD_SDTime = (DateTime?)SqlHelper.GetDBnullValue(dr["DD_SDTime"]),
DD_ZDTime = (DateTime?)SqlHelper.GetDBnullValue(dr["DD_ZDTime"]),
DD_HSTime = dr["DD_HSTime"].ToString(),
DD_ReseTime = (DateTime?)SqlHelper.GetDBnullValue(dr["DD_ReseTime"])
};
return(dD_Infor);
}
/// <summary>
/// 重新按时间节点重置确认时间
/// </summary>
/// <returns></returns>
private static List <DD_InforMation> GetNweTime()
{
List <DD_InforMation> inforMations = new List <DD_InforMation>();
DD_InforMationDAL dal = new DD_InforMationDAL();
var list = dal.GetAlldD_Infors();
foreach (var item in list)
{
string strTime = string.Format("{0:d}", item.DD_QRTime) + " 16:30";
string str1 = string.Format("{0:d}", item.DD_QRTime);
DateTime time1 = Convert.ToDateTime(str1);
DateTime time = Convert.ToDateTime(strTime);
if (IfSaturdayAndSunday.ConvertDateToZHWeek(time1) == "星期天")
{
DD_InforMation dD = AddListIn(item, time1, 1);
inforMations.Add(dD);
}
else
if (IfSaturdayAndSunday.ConvertDateToZHWeek(time1) == "星期六")
{
if (DateTime.Compare(Convert.ToDateTime(item.DD_QRTime.ToString()), time) > 0)
{
DD_InforMation dD = AddListIn(item, time1, 2);
inforMations.Add(dD);
}
else
{
DD_InforMation dD = AddListIn(item, time1, 0);
inforMations.Add(dD);
}
}
else
if (DateTime.Compare(Convert.ToDateTime(item.DD_QRTime.ToString()), time) > 0)
{
DD_InforMation dD = AddListIn(item, time1, 1);
inforMations.Add(dD);
}
else
{
DD_InforMation dD = AddListIn(item, time1, 0);
inforMations.Add(dD);
}
}
return(inforMations);
}
private static void NewMethod(DD_InforMationDAL inforMationDAL, List <DD_InforMation> list)
{
foreach (var item in list)
{
DD_InforMation dD_Infor = new DD_InforMation
{
AutoID = item.AutoID,
DD_BMNum = item.DD_BMNum,
DD_HSTime = item.DD_HSTime,
DD_KFNume = item.DD_KFNume,
DD_QRTime = item.DD_QRTime,
DD_ReseTime = item.DD_ReseTime,
DD_RQTime = item.DD_RQTime,
DD_SDTime = item.DD_SDTime,
DD_ZDTime = item.DD_ZDTime
};
inforMationDAL.Update(dD_Infor);
}
}
private static DD_InforMation AddListIn(DD_InforMation item, DateTime time, double val)
{
DateTime time1 = Convert.ToDateTime(string.Format("{0:d}", item.DD_SDTime));
DateTime time2 = Convert.ToDateTime(time.AddDays(val));
TimeSpan span = time1.Subtract(time2);
return(new DD_InforMation
{
AutoID = item.AutoID,
DD_BMNum = item.DD_BMNum,
DD_HSTime = Convert.ToString(span.Days),
DD_KFNume = item.DD_KFNume,
DD_QRTime = item.DD_QRTime,
DD_ReseTime = time.AddDays(val),
DD_RQTime = item.DD_RQTime,
DD_SDTime = item.DD_SDTime,
DD_ZDTime = item.DD_ZDTime
});
}
