private void fromQualityComplete_Load ( object sender, EventArgs e)
{
var order = m_vh. Grid. FocusedRowHandle;
var row = m_vh. Grid. GetDataRow ( order) ;
Order = row. Field< string> ( "cOrder" ) ;
dtPickerDate. Text = DateTime. Now. ToString ( "yyyy-MM-dd" ) ;
sql = "select a.dNewDate,b.cSubjectContent,c.cPsnName from HV_QualityOrder_h a "
+ "left join HV_QualityOrder_b b on b.QOhId = a.QOhId "
+ "left join EI_Person c on c.pk_person = b.pk_person "
+ "where cOrder = '" + Order + "'" ;
var dt = m_vh. User. GetTable ( sql) ;
var dr = dt. Rows[ 0 ] ;
txtKTOrder. Text = Order;
txtKTName. Text = dr[ "cSubjectContent" ] . ToString ( ) ;
txtRes. Text = dr[ "cPsnName" ] . ToString ( ) ;
dateNewTxt = dr[ "dNewDate" ] . ToString ( ) ;
sql = "select pk_rating,cRating from HI_QualityRating order by pk_rating " ;
var dtRating = m_vh. User. GetTable ( sql) ;
lUpEditRating. Properties. DataSource = dtRating;
lUpEditRating. Properties. ValueMember = "pk_rating" ;
lUpEditRating. Properties. DisplayMember = "cRating" ;
lUpEditRating. Properties. ShowHeader = false ;
lUpEditRating. Properties. ShowFooter = false ;
lUpEditRating. Properties. PopulateColumns ( ) ;
lUpEditRating. Properties. Columns[ "pk_rating" ] . Visible = false ;
lUpEditRating. ItemIndex = 2 ;
lUpEditRating. EditValue = 3 ;
}
private void btnSave_Click ( object sender, EventArgs e)
{
var datetxt = Convert. ToDateTime ( dtPickerDate. EditValue) . ToString ( "yyyy-MM-dd" ) ;
DateTime date = Convert. ToDateTime ( datetxt) ;
DateTime dateNew = Convert. ToDateTime ( dateNewTxt) ;
idRating = lUpEditRating. EditValue. ToString ( ) ;
if ( date < dateNew)
{
MessageBox. Show ( "实际完成时间不能小于制单日期!" , "提示" ) ;
return ;
}
else
{
sql = "update HV_QualityOrder_b set iReference = 1, dActualTime = '" + datetxt + "',"
+ "pk_rating = '" + int. Parse ( idRating) + "' where cOrder = '" + Order + "'" ;
m_vh. User. DoSql ( sql, "" ) ;
m_vh. Refresh ( ) ;
Close ( ) ;
QCLog. AddUpdateLog ( "UPDATE" , sql) ;
}
}