public ShiftCheckRowValidator(WizardContext context) { //未指定 CheckField 時不進行驗證。 _skip_validate = (context.ShiftCheckField == null); if (_skip_validate) { return; } _check_field = context.ShiftCheckField; List <string> requireFields = new List <string>(); requireFields.AddRange(context.IdentifyField.Fields.ToInternalNames()); requireFields.Add(context.ShiftCheckField.InternalName); XmlElement recordData = context.DataSource.GetShiftCheckList(requireFields.ToArray()); List <ImportCondition> cond = new List <ImportCondition>(); cond.Add(context.IdentifyField); _key_sets = new ConditionKeySetCollection(cond, recordData, "Record"); }
private void GenerateInsertXml(SheetRowSource sheetSource, XmlElement record) { foreach (string eachField in Context.SelectedFields) { ImportField field = Context.SupportFields[eachField]; XmlElement xmlField = CreateChild(record, field.InternalName); xmlField.InnerText = sheetSource.GetFieldData(eachField); } }
public static string GetImportField(RestCommand command, int importFieldID) { ImportField importField = ImportFields.GetImportField(command.LoginUser, importFieldID); if (importField.OrganizationID != command.Organization.OrganizationID) { throw new RestException(HttpStatusCode.Unauthorized); } return(importField.GetXml("ImportField", true)); }
private bool UpdateCourseRequired() { foreach (string each in Context.SelectedFields) { ImportField field = Context.SupportFields[each]; if (field.IsBasicField) { return(true); } } return(false); }
private void GenerateUpdateXml(SheetRowSource sheetSource, XmlElement record) { foreach (string eachField in Context.SelectedFields) { ImportField field = Context.SupportFields[eachField]; XmlElement xmlField = CreateChild(record, field.InternalName); xmlField.InnerText = sheetSource.GetFieldData(eachField); } XmlElement condition = CreateChild(record, "Condition"); foreach (ImportField each in Context.IdentifyField.Fields) { XmlElement xmlField = CreateChild(condition, each.InternalName); xmlField.InnerText = sheetSource.GetFieldData(each.FieldName); } }
/// <summary> /// Instructs import command to check for duplicate contacts base on a given field /// </summary> /// <param name="field">The field according which the duplicate contact will be determined. For example ImportField.FullName</param> /// <returns></returns> public ImportFileCommand CheckingForDuplicate(ImportField field) { switch (field) { case ImportField.FullName: { checkForDuplicateFullName = true; break; } case ImportField.ContactEmail: { checkForDuplicateContactEmail = true; break; } case ImportField.OrganizationName: { checkForDuplicateOrganizationName = true; break; } case ImportField.OrganizationEmail: { checkForDuplicateCompanyEmail = true; break; } case ImportField.MainPhone: { checkForDuplicateMainPhone = true; break; } default: { break; } } return(this); }
private void wpCollectKeyInfo_NextButtonClick(object sender, CancelEventArgs e) { e.Cancel = true; if (cboIdField.SelectedIndex == -1) { FISCA.Presentation.Controls.MsgBox.Show("您必須要選擇識別欄位。"); return; } ImportCondition condition = cboIdField.SelectedItem as ImportCondition; if (condition != null) { Context.IdentifyField = condition; } ImportField field = cboValidateField.SelectedItem as ImportField; if (field == EmptyShiftField) { Context.ShiftCheckField = null; } else { Context.ShiftCheckField = field; } if (Context.ShiftCheckField != null) { if (Context.IdentifyField.ContainsAnyField(Context.ShiftCheckField.FieldName)) { FISCA.Presentation.Controls.MsgBox.Show("「識別欄」與「驗證欄」必須是不同的欄位。"); return; } } e.Cancel = false; }
public SheetField(ImportField field) { _field = field; Text = field.FieldName; }
//------------------------------------------------------------- // // //------------------------------------------------------------- private void createImportFieldList(ImportFieldRow importRow) { ImportParams importParams = (ImportParams)Session["importparams"]; List <ImportField> fieldList = importRow.ImportFieldsList; for (int j = 0; j < fieldList.Count; j++) { ImportField field = (ImportField)fieldList[j]; string value = ""; field.FieldValue = field.FieldValue.Replace("'", "''"); switch (field.FieldType.ToLower()) { case "decimal": case "money": value = field.FieldValue.Trim() == "" ? "null" : field.FieldValue; Double dValue = 0; if (value != null && value != "null") { try { //------------------------------------- // We check to see if it is a proper // value being passed, if not we reset it. //------------------------------------- dValue = Convert.ToDouble(value); } catch { field.FieldValue = "null"; value = "null"; } } break; case "integer": value = field.FieldValue.Trim() == "" ? "null" : field.FieldValue; Int16 iValue = 0; if (value != null && value != "null") { try { //------------------------------------- // We check to see if it is a proper // value being passed, if not we reset it. //------------------------------------- iValue = Convert.ToInt16(value); } catch { field.FieldValue = "null"; value = "null"; } } break; case "date": value = field.FieldValue.Trim() == "" ? "null" : "'" + field.FieldValue + "'"; break; case "boolean": value = field.FieldValue.Trim() == "" ? "null" : field.FieldValue; if (value != null && value != "null" && (value.ToUpper() == "TRUE" || value != "0")) { value = "1"; } else { value = "0"; } break; default: value = field.FieldValue.Trim() == "" ? "null" : "'" + field.FieldValue + "'"; break; } if (field.FieldName != "NeverCallFlag" || importParams.exceptionType == 1) { if (sqlCols == string.Empty) { sqlCols = field.FieldName; sqlValues = value; strUpdate = String.Format("{0}={1}", field.FieldName, value); } else { sqlCols += "," + field.FieldName; sqlValues += "," + value; strUpdate += ", " + String.Format("{0}={1}", field.FieldName, value); } } if (field.FieldName == "PhoneNum") { strPhoneNumber = field.FieldValue; } }// end for loop forceNeverCallFlag(); }
//----------------------------------------------------------------- // // //----------------------------------------------------------------- private void SetFieldValue(ImportFieldRow row, string field, string value, string datatype) { List <ImportField> list = row.ImportFieldsList; switch (datatype.ToLower()) { case "integer": if (value.Trim() != "" && (!IsInt(value))) { value = value.Trim().ToLower(); if (value == "true" || value == "yes") { value = "1"; } else if (value == "false" || value == "no") { value = "0"; } else { throw new Exception("BadInputData"); } } break; case "boolean": if (value.Trim() != "") { value = value.Trim().ToLower(); if (value == "true" || value == "yes") { value = "1"; } else if (value == "false" || value == "no") { value = "0"; } else if (IsBool(value)) { value = Convert.ToBoolean(value) ? "1" : "0"; } else if (IsInt(value)) { value = Convert.ToBoolean(Convert.ToInt32(value)) ? "1" : "0"; } else { throw new Exception("BadInputData"); } } break; case "date": if (value.Trim() != "" && (!IsDateTime(value))) { throw new Exception("BadInputData"); } break; case "decimal": case "money": if (value.Trim() != "" && (!IsDouble(value))) { throw new Exception("BadInputData"); } break; } ImportField impField = new ImportField(); impField.FieldName = field; impField.FieldValue = value; //Server.UrlEncode(value); impField.FieldType = datatype; list.Add(impField); }