public bool UpdateWorkOrder(int word_WOnum, string word_Proj, int?word_StatNum,
string word_Status, int?word_statFlag, DateTime word_Date, string word_Author,
string word_Title, string word_Doc, string word_DocVer, int?word_Priority,
string word_Descr, string word_Justify, string word_Cmnts,
int?word_PMorSME, int?word_BusnOwner, DateTime?word_reqDueDate, int Original_word_WOnum, string Original_word_Proj)
{
WorkOrder.WorkOrderDataTable WrkOrds = WOadapter.GetWOByNumProj(word_WOnum, word_Proj);//new WorkOrder.WorkOrderDataTable();
if (WrkOrds.Count == 0)
{
return(false);
}
WorkOrder.WorkOrderRow WrkOrd = WrkOrds[0];
// do data insertions
WrkOrd.word_Proj = word_Proj;
word_WOnum = GetMaxWOnum(word_Proj);
if (word_StatNum == null)
{
WrkOrd.Setword_StatNumNull();
}
else
{
WrkOrd.word_StatNum = word_StatNum.Value;
}
if (word_Status == null)
{
WrkOrd.Setword_StatusNull();
}
else
{
WrkOrd.word_Status = word_Status;
}
if (word_statFlag == null)
{
WrkOrd.word_statFlag = 0;
}
else
{
WrkOrd.word_statFlag = word_statFlag.Value;
}
if (word_Date == null)
{
WrkOrd.Setword_DateNull();
}
else
{
WrkOrd.word_Date = word_Date;
}
if (word_Author == null)
{
WrkOrd.Setword_AuthorNull();
}
else
{
WrkOrd.word_Author = word_Author;
}
if (word_Title == null)
{
WrkOrd.Setword_TitleNull();
}
else
{
WrkOrd.word_Title = word_Title;
}
if (word_Doc == null)
{
WrkOrd.Setword_DocNull();
}
else
{
WrkOrd.word_Doc = word_Doc;
}
if (word_DocVer == null)
{
WrkOrd.Setword_DocVerNull();
}
else
{
WrkOrd.word_DocVer = word_DocVer;
}
if (word_Priority == null)
{
WrkOrd.Setword_PriorityNull();
}
else
{
WrkOrd.word_Priority = word_Priority.Value;
}
if (word_Descr == null)
{
WrkOrd.Setword_DescrNull();
}
else
{
WrkOrd.word_Descr = word_Descr;
}
if (word_Justify == null)
{
WrkOrd.Setword_JustifyNull();
}
else
{
WrkOrd.word_Justify = word_Justify;
}
if (word_Cmnts == null)
{
WrkOrd.Setword_CmntsNull();
}
else
{
WrkOrd.word_Cmnts = word_Cmnts;
}
if (word_PMorSME == null)
{
WrkOrd.Setword_PMorSMENull();
}
else
{
WrkOrd.word_PMorSME = word_PMorSME.Value;
}
if (word_BusnOwner == null)
{
WrkOrd.Setword_BusnOwnerNull();
}
else
{
WrkOrd.word_BusnOwner = word_BusnOwner.Value;
}
if (word_reqDueDate == null)
{
WrkOrd.Setword_reqDueDateNull();
}
else
{
WrkOrd.word_reqDueDate = word_reqDueDate.Value;
}
int rowsAffected = WOadapter.Update(WrkOrds);
//int rowsAffected = WOadapter.Update(WrkOrd.word_WOnum, WrkOrd.word_Proj, WrkOrd.word_StatNum,
//WrkOrd.word_Status, WrkOrd.word_statFlag, WrkOrd.word_Date, WrkOrd.word_Author,
//WrkOrd.word_Title, WrkOrd.word_Doc, WrkOrd.word_DocVer, WrkOrd.word_Priority,
//WrkOrd.word_Descr, WrkOrd.word_Justify, WrkOrd.word_Cmnts,
//WrkOrd.word_PMorSME, WrkOrd.word_BusnOwner, WrkOrd.word_reqDueDate, WrkOrd.word_WOnum, WrkOrd.word_Proj);
return(rowsAffected == 1);
}
public WorkOrder.WorkOrderDataTable GetWorkOrdersByWOnumProj(int wonum, string proj)
{
return(WOadapter.GetWOByNumProj(wonum, proj));
}