private void Child_Update(SortingTaskIssued sortingTaskIssued, MySqlConnection cn) { using (BypassPropertyChecks) { using (var cm = cn.CreateCommand()) { StringBuilder SQL = new StringBuilder(); SQL.Append("INSERT "); SQL.Append(" INTO T_SORTINGTASKISSUEDDETAIL "); SQL.Append(" ( "); SQL.Append(" ID,TASKID,LINEBOXCODE,ADDRESSCODE,QTY "); SQL.Append(" ) "); SQL.Append(" VALUES "); SQL.Append(" ( "); SQL.Append(" @ID,@TASKID,@LINEBOXCODE,@ADDRESSCODE,@QTY "); SQL.Append(" )"); cm.CommandText = SQL.ToString(); cm.Parameters.AddWithValue("@ID", ID); cm.Parameters.AddWithValue("@TASKID", ""); cm.Parameters.AddWithValue("@LINEBOXCODE", LINEBOXCODE); cm.Parameters.AddWithValue("@ADDRESSCODE", ADDRESSCODE); cm.Parameters.AddWithValue("@QTY", QTY); cm.ExecuteNonQuery(); } } }
protected void Child_Update(SortingTaskIssued sortingTaskIssued, MySqlTransaction tran) { foreach (SortingTaskIssuedDetail sortingTaskIssuedDetail in this) { sortingTaskIssuedDetail.Save(sortingTaskIssued, tran); } }
public void Save(SortingTaskIssued sortingTaskIssued, MySqlTransaction cn) { DataPortal.UpdateChild(this, new object[] { sortingTaskIssued, cn }); }