internal static void Merge(DataSet targetSet, DataRow[] sourceRows, bool preserveChanges, MissingSchemaAction missingSchemaAction)
{
if(targetSet == null)
throw new ArgumentNullException("targetSet");
if(sourceRows == null)
throw new ArgumentNullException("sourceRows");
bool savedEnfoceConstraints = targetSet.EnforceConstraints;
targetSet.EnforceConstraints = false;
ArrayList targetTables = new ArrayList();
for (int i = 0; i < sourceRows.Length; i++) {
DataRow row = sourceRows[i];
DataTable sourceTable = row.Table;
DataTable targetTable = null;
if (!AdjustSchema(targetSet, sourceTable, missingSchemaAction,ref targetTable)) {
return;
}
if (targetTable != null) {
checkColumnTypes(targetTable, row.Table);
MergeRow(targetTable, row, preserveChanges);
if (!(targetTables.IndexOf(targetTable) >= 0)) {
targetTables.Add(targetTable);
}
}
}
targetSet.EnforceConstraints = savedEnfoceConstraints;
foreach(DataTable table in targetTables) {
table.ResetIndexes();
}
}
private static void ApplyFyCzInterService(DataRow drRow)
{
AutoPlanEntity _autohotelplanEntity = new AutoPlanEntity();
_autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>();
AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity();
_autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
string AgentID = ConfigurationManager.AppSettings["AgentID"].ToString();
string Money = ConfigurationManager.AppSettings["FYMON"].ToString();
appcontentDBEntity.AgentId = AgentID;
appcontentDBEntity.Money = Money;
appcontentDBEntity.OrderId = drRow["RESVID"].ToString().Trim();
appcontentDBEntity.MobileNum = drRow["MOBILE"].ToString().Trim();
appcontentDBEntity.UNIT_ID = drRow["UNIT_ID"].ToString().Trim();
appcontentDBEntity.ORDER_STATUS = drRow["ORDER_STATUS"].ToString().Trim();
appcontentDBEntity.NAME = drRow["NAME"].ToString().Trim();
appcontentDBEntity.ARRD = drRow["ARRD"].ToString().Trim();
appcontentDBEntity.DEPD = drRow["DEPD"].ToString().Trim();
appcontentDBEntity.CHANNEL = drRow["CHANNEL"].ToString().Trim();
appcontentDBEntity.PLATFORM_CODE = drRow["PLATFORM_CODE"].ToString().Trim();
appcontentDBEntity.GUEST_ID = drRow["GUEST_TD"].ToString().Trim(); ;
_autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
AutoHotelPlanSA.ApplyFYCZInterface(_autohotelplanEntity);
}
public void DataToField(DataRow row, object record) // TypedReference t)
{
try
{
GetColumnIndex(row);
if (mCheckTypeFlag == 0)
{
mColumnType = row.Table.Columns[mDataColumnIndex].DataType;
if (mColumnType == mField.FieldType)
mCheckTypeFlag = 1;
else
mCheckTypeFlag = 2;
}
if (mCheckTypeFlag == 1)
mField.SetValue(record, row[mDataColumnIndex]);
else if (row[mDataColumnIndex] != DBNull.Value)
mField.SetValue(record, Convert.ChangeType(row[mDataColumnIndex], mField.FieldType));
else // IS DB NULl
{
if (mColumnType == typeof (string))
mField.SetValue(record, string.Empty);
}
}
catch
{
throw new FileHelpersException(string.Format("Error converting value: {0} to {1} in the column with index {2} and the field {3}", row[mDataColumnIndex], mField.FieldType, mDataColumnIndex, mField.Name));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HisClient.Model.his_comm_dict_type DataRowToModel(DataRow row)
{
HisClient.Model.his_comm_dict_type model=new HisClient.Model.his_comm_dict_type();
if (row != null)
{
if(row["ID"]!=null)
{
model.ID=row["ID"].ToString();
}
if(row["TYPE_CODE"]!=null)
{
model.TYPE_CODE=row["TYPE_CODE"].ToString();
}
if(row["TYPE_NAME"]!=null)
{
model.TYPE_NAME=row["TYPE_NAME"].ToString();
}
if(row["HELP_CODE"]!=null)
{
model.HELP_CODE=row["HELP_CODE"].ToString();
}
if(row["CREATE_DATE"]!=null && row["CREATE_DATE"].ToString()!="")
{
model.CREATE_DATE=DateTime.Parse(row["CREATE_DATE"].ToString());
}
if(row["CREATE_BY"]!=null)
{
model.CREATE_BY=row["CREATE_BY"].ToString();
}
}
return model;
}
public override void DataBind(DataRow row)
{
base.DataBind(row);
this.PONum = (int)row["PONum"].GetInt();
this.PONumber = (string)row["PONumber"].GetString();
}
public void FillForm()
{
da.Fill(ds, "members");
row = ds.Tables[0].Rows[0];
TextBox1.Text = row["name"].ToString();
TextBox2.Text = row["email"].ToString();
TextBox3.Text = row["contact"].ToString();
TextBox4.Text = row["college"].ToString();
TextBox5.Text = row["branch"].ToString();
TextBox6.Text = row["course"].ToString();
TextBox7.Text = row["company"].ToString();
TextBox8.Text = row["company_location"].ToString();
TextBox9.Text = row["password"].ToString();
if (row["gender"].Equals("M"))
RadioButton2.Checked = true;
else
RadioButton1.Checked = true;
if (row["membership"].Equals("S"))
RadioButton3.Checked = true;
else
RadioButton4.Checked = true;
for(int i=DateTime.Now.Year;i>=1950;i--)
DropDownList1.Items.Add("" + i);
DropDownList1.SelectedValue = row["year_of_passing"].ToString();
}
public virtual void DataBind(DataRow row)
{
this.CommodityCode = (string)row["Key1"];
this.CommodityName = (string)row["Character01"];
this.CoatingRequire = Convert.ToBoolean(row["CheckBox01"].GetBoolean());
this.LicenceRequire = Convert.ToBoolean(row["CheckBox02"].GetBoolean());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.Admin.Model.Logs DataRowToModel(DataRow row)
{
ECommerce.Admin.Model.Logs model = new ECommerce.Admin.Model.Logs();
if (row != null)
{
if (row["LID"] != null && row["LID"].ToString() != "")
{
model.LID = Convert.ToInt64(row["LID"].ToString());
}
if (row["LLID"] != null && row["LLID"].ToString() != "")
{
model.LLID = Convert.ToInt64(row["LLID"].ToString());
}
if (row["OValue"] != null)
{
model.OValue = row["OValue"].ToString();
}
if (row["NValue"] != null)
{
model.NValue = row["NValue"].ToString();
}
if (row["FName"] != null)
{
model.FName = row["FName"].ToString();
}
}
return model;
}
public ElectricityParameter(DataRow row)
{
this.ID = (int)row["ID"];
if (row["PowerRate"] != DBNull.Value)
this.PowerRate = (Double)row["PowerRate"];
if (row["CoActiveCopperLoss"] != DBNull.Value)
this.CoActiveCopperLoss = (Double)row["CoActiveCopperLoss"];
if (row["CoActiveNoloadLoss"] != DBNull.Value)
this.CoActiveNoloadLoss = (Double)row["CoActiveNoloadLoss"];
if (row["CoReactiveCopperLoss"] != DBNull.Value)
this.CoReactiveCopperLoss = (Double)row["CoReactiveCopperLoss"];
if (row["CoReactiveNoloadLoss"] != DBNull.Value)
this.CoReactiveNoloadLoss = (Double)row["CoReactiveNoloadLoss"];
if (row["PriceSpike"] != DBNull.Value)
this.PriceSpike = (Double)row["PriceSpike"];
if (row["PricePeak"] != DBNull.Value)
this.PricePeak = (Double)row["PricePeak"];
if (row["PriceValley"] != DBNull.Value)
this.PriceValley = (Double)row["PriceValley"];
}
public static Pet GetPetFromDatabaseRow(DataRow Row)
{
return new Pet((uint)Row["id"], (string)Row["name"], (int)Row["type"], (int)Row["race"],
(uint)Row["user_id"], (uint)Row["room_id"], Vector3.FromString((string)Row["room_pos"]),
(double)Row["timestamp"], (int)Row["experience"], (int)Row["energy"], (int)Row["happiness"],
(int)Row["score"]);
}
public UCPersonnelAddOrEdit(DataRow dr, string parentName)
{
InitializeComponent();
this.dr = dr;
this.parentName = parentName;
Update = new UpdateDele(DBHelper.WebServHandlerByFun);
}
public static DbProviderFactory GetFactory(DataRow providerRow)
{
ADP.CheckArgumentNull(providerRow, "providerRow");
DataColumn column = providerRow.Table.Columns["AssemblyQualifiedName"];
if (column != null)
{
string str = providerRow[column] as string;
if (!ADP.IsEmpty(str))
{
Type type = Type.GetType(str);
if (null == type)
{
throw ADP.ConfigProviderNotInstalled();
}
FieldInfo field = type.GetField("Instance", BindingFlags.Public | BindingFlags.Static | BindingFlags.DeclaredOnly);
if ((null != field) && field.FieldType.IsSubclassOf(typeof(DbProviderFactory)))
{
object obj2 = field.GetValue(null);
if (obj2 != null)
{
return (DbProviderFactory) obj2;
}
}
throw ADP.ConfigProviderInvalid();
}
}
throw ADP.ConfigProviderMissing();
}
public virtual void DataBind(DataRow row)
{
this.PONum = (int)row["PONum"].GetInt();
this.Revision = (int)row["Revision"].GetInt();
this.OpenOrder = (int)row["OpenOrder"].GetInt();
this.VoidOrder = (int)row["VoidOrder"].GetInt();
this.EntryPerson = (string)row["EntryPerson"].GetString();
this.OrderDate = (DateTime)row["OrderDate"].GetDate();
this.TermsCode = (string)row["TermsCode"].GetString();
this.VendorNum = (int)row["VendorNum"].GetInt();
this.SupplierName = (string)row["SupplierName"].GetString();
this.CurrencyCode = (string)row["CurrencyCode"].GetString();
this.ExchangeRate = (int)row["ExchangeRate"].GetInt();
this.ApprovedDate = (DateTime)row["ApprovedDate"].GetDate();
this.ApprovedBy = (string)row["ApprovedBy"].GetString();
this.Approve = (int)row["Approve"].GetInt();
this.ApprovalStatus = (string)row["ApprovalStatus"].GetString();
this.ApprovedAmount = (int)row["ApprovedAmount"].GetInt();
this.CustId = (string)row["CustId"].GetString();
this.CustomerName = (string)row["CustomerName"].GetString();
this.MakerCode = (string)row["MakerCode"].GetString();
this.MakerName = (string)row["MakerName"].GetString();
this.MillCode = (string)row["MillCode"].GetString();
this.MillName = (string)row["MillName"].GetString();
this.SaleContractNum = (string)row["SaleContractNum"].GetString();
this.SaleContractDate = (DateTime)row["SaleContractDate"].GetDate();
this.ImportCode = (string)row["ImportCode"].GetString();
this.CalculateCode = (string)row["CalculateCode"].GetString();
this.SectionCode = (string)row["SectionCode"].GetString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.friendchange DataRowToModel(DataRow row)
{
la.Model.friendchange model=new la.Model.friendchange();
if (row != null)
{
if(row["friendchange_ID"]!=null && row["friendchange_ID"].ToString()!="")
{
model.friendchange_ID=int.Parse(row["friendchange_ID"].ToString());
}
if(row["friend_id"]!=null && row["friend_id"].ToString()!="")
{
model.friend_id=int.Parse(row["friend_id"].ToString());
}
if(row["user_telphone"]!=null)
{
model.user_telphone=row["user_telphone"].ToString();
}
if(row["friendchange_time"]!=null && row["friendchange_time"].ToString()!="")
{
model.friendchange_time=DateTime.Parse(row["friendchange_time"].ToString());
}
if(row["friendchange_op"]!=null)
{
model.friendchange_op=row["friendchange_op"].ToString();
}
if(row["friendchange_comment"]!=null)
{
model.friendchange_comment=row["friendchange_comment"].ToString();
}
}
return model;
}
private void Init(DataRow dataRow)
{
if (_dataRow == null && dataRow != null)
_createColumns = dataRow.Table.Columns.Count == 0;
_dataRow = dataRow;
}
private EntityHandler.CustomerMaster ConvertToObject(DataRow row)
{
EntityHandler.CustomerMaster obj = new EntityHandler.CustomerMaster();
try
{
// obj.Active = Convert.ToInt32(row["Active"].ToString());
//obj.Address = row["Address"].ToString();
// obj.ApprovedBy = Convert.ToInt32(row["ApprovedBy"].ToString());
// obj.ApprovedDate = Convert.ToDateTime(row["ApprovedDate"].ToString());
// obj.Area = Convert.ToInt32(row["Area"].ToString());
// obj.Category = row["Category"].ToString();
// obj.Credits_Limits = Convert.ToDecimal(row["Credits_Limits"].ToString());
// obj.CusFINCode = row["CusFINCode"].ToString();
obj.Customer_Code = Convert.ToInt32(row["Customer_Code"].ToString());
// obj.Customer_Type = row["Customer_Type"].ToString();
//obj.Date = DateTime.Parse(row["Date"].ToString());
obj.Name = row["Name"].ToString();
// obj.Other_Names = row["Other_Names"].ToString();
// obj.ProductCategory = row["ProductCategory"].ToString();
// obj.SalesMethod = row["SalesMethod"].ToString();
// obj.Status = Convert.ToInt32(row["Status"].ToString());
// obj.UserID = Convert.ToInt32(row["UserID"].ToString());
}
catch (Exception ex)
{ }
return obj;
}
protected override RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command,
StatementType statementType,
DataTableMapping tableMapping)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, "CreateRowUpdatedEvent");
return new NpgsqlRowUpdatedEventArgs(dataRow, command, statementType, tableMapping);
}
public Volunteer(DataRow row)
{
this.ID = (int)row["ID"];
this.FirstName = row["FirstName"] as string;
this.MiddleNames = row["MiddleName"] as string;
this.LastName = row["Surname"] as string;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DataRow dr, SqlTransaction trans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO hrCompanyShopInfo(");
strSql.Append("MainID,sShopID,sShopCName,sShopEName,sRemark,sUserID)");
strSql.Append(" VALUES (");
strSql.Append("@MainID,@sShopID,@sShopCName,@sShopEName,@sRemark,@sUserID)");
strSql.Append(";SELECT @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MainID", SqlDbType.Int,4),
new SqlParameter("@sShopID", SqlDbType.VarChar,30),
new SqlParameter("@sShopCName", SqlDbType.VarChar,50),
new SqlParameter("@sShopEName", SqlDbType.VarChar,50),
new SqlParameter("@sRemark", SqlDbType.VarChar,200),
new SqlParameter("@sUserID", SqlDbType.VarChar,30)};
parameters[0].Value = dr["MainID"];
parameters[1].Value = dr["sShopID"];
parameters[2].Value = dr["sShopCName"];
parameters[3].Value = dr["sShopEName"];
parameters[4].Value = dr["sRemark"];
parameters[5].Value = dr["sUserID"];
object obj = DbHelperSQL.GetSingle(strSql.ToString(), trans, parameters);
if (obj == null)
{
return -1;
}
else
{
return Convert.ToInt32(obj);
}
}
public string Create( DataRow p)
{
string id = Guid.NewGuid().ToString();
string sql = "";
sql = " insert into Templet( "
+" id, "
+ " corp_id,"
+ " name,"
+ " docpath,"
+ " creatorid,"
+ " createtime,"
+ " status"
+ " ) values("
+ " '" + StringHelper.ChkSQL(id) + "',"
+ " '" + StringHelper.ChkSQL(p["corp_id"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["name"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["docpath"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["creatorid"].ToString()) + "',"
+ " getdate() ,"
+ " 1 " //status
+ " ) ";
commonDAL.ExecSQL( sql);
return id;
}
private void AddProduto_Click(object sender, EventArgs e)
{
try
{
linha[3] = TxtBoxQuantUnit.Text;
linha[4] = TxtBoxPreco.Text;
linha[5] = Convert.ToString(Convert.ToDouble(TxtBoxDescontoUnit.Text) / (Convert.ToDouble(TxtBoxQuantUnit.Text) * Convert.ToDouble(TxtBoxPreco.Text)) * 100) + " %";
linha[6] = TxtBoxDescontoUnit.Text;
linha[7] = (Convert.ToDouble(TxtBoxQuantUnit.Text) * Convert.ToDouble(TxtBoxPreco.Text)) - Convert.ToDouble(TxtBoxDescontoUnit.Text);
foreach (DataGridViewRow Dr in LsVyPdVenda.Rows)
{
if (Dr.Cells[0].Value.ToString() == TxtBoxProduto.Text.Trim())
{
MessageBox.Show("O produto " + TxtBoxProduto.Text.Trim() + " já está na grade.", "Item em Duplicidade", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
mDataTable.Rows.Add(linha);
LsVyPdVenda.DataSource = mDataTable;
linha = mDataTable.NewRow();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Não foi possível inserir este produto na grade: " + ex.Message.ToString(), "Produto", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="TypedUserFind"/> class.
/// </summary>
/// <param name="row">
/// The row.
/// </param>
public TypedUserFind(DataRow row)
{
this.UserID = row.Field<int?>("UserID");
this.BoardID = row.Field<int?>("BoardID");
this.Name = row.Field<string>("Name");
this.Password = row.Field<string>("Password");
this.Email = row.Field<string>("Email");
this.Joined = row.Field<DateTime?>("Joined");
this.LastVisit = row.Field<DateTime?>("LastVisit");
this.IP = row.Field<string>("IP");
this.NumPosts = row.Field<int?>("NumPosts");
this.TimeZone = row.Field<int?>("TimeZone");
this.Avatar = row.Field<string>("Avatar");
this.Signature = row.Field<string>("Signature");
this.AvatarImage = row.Field<byte[]>("AvatarImage");
this.RankID = row.Field<int?>("RankID");
this.Suspended = row.Field<DateTime?>("Suspended");
this.LanguageFile = row.Field<string>("LanguageFile");
this.ThemeFile = row.Field<string>("ThemeFile");
this.Flags = row.Field<int?>("Flags");
this.PMNotification = row.Field<bool?>("PMNotification");
this.Points = row.Field<int?>("Points");
this.IsApproved = row.Field<bool?>("IsApproved");
this.IsActiveExcluded = row.Field<bool?>("IsActiveExcluded");
this.UseMobileTheme = row.Field<bool?>("OverrideDefaultThemes");
this.AvatarImageType = row.Field<string>("AvatarImageType");
this.AutoWatchTopics = row.Field<bool?>("AutoWatchTopics");
this.TextEditor = row.Field<string>("TextEditor");
this.DisplayName = row.Field<string>("DisplayName");
this.Culture = row.Field<string>("Culture");
this.NotificationType = row.Field<int?>("NotificationType");
this.DailyDigest = row.Field<bool?>("DailyDigest");
this.IsGuest = row.Field<bool>("IsGuest");
this.ProviderUserKey = this.IsGuest ? null : ObjectExtensions.ConvertObjectToType(row.Field<string>("ProviderUserKey"), Config.ProviderKeyType);
}
public override void LoadData(DataRow CurrentDataRow, IDbConnection conn)
{
IsLoaded = false;
CurrentFRDBase = (GISADataset.FRDBaseRow)CurrentDataRow;
IsLoaded = true;
}
public static void SpellViewInfo(DataRow spellInfo, RichTextBox _rtSpellInfo)
{
_rtSpellInfo.SelectionColor = Color.Blue;
_rtSpellInfo.AppendText(ViewTextInfo(spellInfo));
_rtSpellInfo.SelectionColor = Color.Black;
_rtSpellInfo.AppendText(ViewAttribute(spellInfo));
_rtSpellInfo.AppendText(ViewMask(spellInfo));
_rtSpellInfo.AppendText(ViewProcFlag(spellInfo));
_rtSpellInfo.AppendText(ViewFlags(spellInfo));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc1)));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc2)));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc3)));
_rtSpellInfo.AppendText(ViewInfoFromOtherTable(spellInfo));
_rtSpellInfo.AppendText(ViewReagent(spellInfo));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFields2), 2));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFields3), 3));
_rtSpellInfo.AppendText(ViewSpellItemInfo(spellInfo));
}
public CUser(String[] ConnectInfo,DataRow dr) : base(ConnectInfo)
{
//根据数据行设置用户的属性
SetUserProperty(dr);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_diancai_shop_setup DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_diancai_shop_setup model=new MxWeiXinPF.Model.wx_diancai_shop_setup();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["wid"]!=null && row["wid"].ToString()!="")
{
model.wid=int.Parse(row["wid"].ToString());
}
if(row["unionManage"]!=null)
{
model.unionManage=row["unionManage"].ToString();
}
if(row["unionTel"]!=null)
{
model.unionTel=row["unionTel"].ToString();
}
if(row["createDate"]!=null && row["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(row["createDate"].ToString());
}
if(row["shopid"]!=null && row["shopid"].ToString()!="")
{
model.shopid=int.Parse(row["shopid"].ToString());
}
}
return model;
}
public Box(DataRow dr)
{
this.ID = Int32.Parse(dr["Id"].ToString());
this.DateIn = DateTime.Parse(dr["Date_In"].ToString());
this.ProductCode = dr["productCode"].ToString();
this.RecipientName = dr["recipient_name"].ToString();
this.RecipientLocation = dr["recipient_loc"].ToString();
this.RecipientAddress = dr["recipient_address"].ToString();
this.RecipientTelefonNumber = dr["recipient_tel"].ToString();
this.RecipientCostCenter = dr["recipient_cc"].ToString();
if (dr["date_out"].ToString().Equals(""))
{
this.DateOut = null;
}
else
{
DateTime d;
DateTime.TryParse(dr["date_out"].ToString(), out d);
this.DateOut = d;
}
this.DeliveredTo = dr["delivered_to"].ToString();
this.Sender = dr["sender"].ToString();
this.Deliverer = dr["deliverer"].ToString();
this.Ware = dr["wareOrDoc"].ToString().ToLower().Contains("ware");
this.Document = dr["wareOrDoc"].ToString().ToLower().Contains("document");
this.Customs = dr["customs"].ToString().Equals("yes");
this.Comment = dr["comment"].ToString();
this.Creator = dr["creator"].ToString();
}
public DataSet FlipDataSet(DataSet my_DataSet)
{
DataSet ds = new DataSet();
DataTable table = new DataTable();
foreach (DataTable dt in my_DataSet.Tables)
{
for (int i = 0; i <= dt.Rows.Count; i++)
{
table.Columns.Add(Convert.ToString(i));
}
for (int k = 0; k < dt.Columns.Count; k++)
{
r = table.NewRow();
r[0] = dt.Columns[k].ToString();
for (int j = 1; j <= dt.Rows.Count; j++)
r[j] = dt.Rows[j - 1][k];
table.Rows.Add(r);
}
ds.Tables.Add(table);
}
return ds;
}
/// <summary>
/// Cerca la relazione che lega una riga Master con una tabella Detail, o in seconda battuta, un riga Detail con una riga Master
/// </summary>
/// <param name="currentRow">Riga corrente Master</param>
/// <param name="ds">DataSet di riferimento</param>
/// <param name="tableName">Nome della tabella Detail</param>
/// <returns>Relazione trovata</returns>
public static DataRelation FoundRelation(DataRow currentRow, DataSet ds, string tableName)
{
DataRelation result = null;
foreach(DataRelation relation in ds.Relations)
{
if(relation.ChildTable.TableName == tableName && relation.ParentTable.TableName == currentRow.Table.TableName)
{
result = relation;
break;
}
}
if(result == null)
{
foreach(DataRelation relation in ds.Relations)
{
if(relation.ChildTable.TableName == currentRow.Table.TableName && relation.ParentTable.TableName == tableName)
{
result = relation;
break;
}
}
}
return result;
}
protected override void ParseTableInfo(DataRow rs)
{
Catalog = null;
Schema = Convert.ToString(rs["OWNER"]);
if (string.IsNullOrEmpty(Schema)) Schema = null;
Name = Convert.ToString(rs["TABLE_NAME"]);
}
/// <summary>
/// This method provides access to the values in each of the columns in a given row.
/// This method makes casts unnecessary when accessing columns.
/// Additionally, Field supports nullable types and maps automatically between DBNull and
/// Nullable when the generic type is nullable.
/// </summary>
/// <param name="row">
/// The input DataRow
/// </param>
/// <param name="columnIndex">
/// The input ordinal specificy which row value to retrieve.
/// </param>
/// <param name="version">
/// The DataRow version for which row value to retrieve.
/// </param>
/// <returns>
/// The DataRow value for the column specified.
/// </returns>
public static T Field <T>(this DataRow row, int columnIndex, DataRowVersion version)
{
DataSetUtil.CheckArgumentNull(row, "row");
return(UnboxT <T> .Unbox(row[columnIndex, version]));
}
private int Eval(BinaryNode expr, DataRow row, DataRowVersion version)
{
if (expr.op == 0x1a)
{
int num4 = this.Eval((BinaryNode)expr.left, row, version);
if (num4 != 0)
{
return(num4);
}
int num3 = this.Eval((BinaryNode)expr.right, row, version);
if (num3 != 0)
{
return(num3);
}
return(0);
}
long num = 0L;
object obj3 = expr.left.Eval(row, version);
if ((expr.op != 13) && (expr.op != 0x27))
{
StorageType type;
object obj2 = expr.right.Eval(row, version);
bool lc = expr.left is ConstNode;
bool rc = expr.right is ConstNode;
if ((obj3 == DBNull.Value) || (expr.left.IsSqlColumn && DataStorage.IsObjectSqlNull(obj3)))
{
return(-1);
}
if ((obj2 == DBNull.Value) || (expr.right.IsSqlColumn && DataStorage.IsObjectSqlNull(obj2)))
{
return(1);
}
StorageType storageType = DataStorage.GetStorageType(obj3.GetType());
if (StorageType.Char == storageType)
{
if (rc || !expr.right.IsSqlColumn)
{
obj2 = Convert.ToChar(obj2, this.table.FormatProvider);
}
else
{
obj2 = SqlConvert.ChangeType2(obj2, StorageType.Char, typeof(char), this.table.FormatProvider);
}
}
StorageType right = DataStorage.GetStorageType(obj2.GetType());
if (expr.left.IsSqlColumn || expr.right.IsSqlColumn)
{
type = expr.ResultSqlType(storageType, right, lc, rc, expr.op);
}
else
{
type = expr.ResultType(storageType, right, lc, rc, expr.op);
}
if (type == StorageType.Empty)
{
expr.SetTypeMismatchError(expr.op, obj3.GetType(), obj2.GetType());
}
num = expr.BinaryCompare(obj3, obj2, type, expr.op);
}
switch (expr.op)
{
case 7:
num = (num == 0L) ? ((long)0) : ((num < 0L) ? ((long)(-1)) : ((long)1));
break;
case 8:
num = (num > 0L) ? ((long)0) : ((long)(-1));
break;
case 9:
num = (num < 0L) ? ((long)0) : ((long)1);
break;
case 10:
num = (num >= 0L) ? ((long)0) : ((long)(-1));
break;
case 11:
num = (num <= 0L) ? ((long)0) : ((long)1);
break;
case 13:
num = (obj3 == DBNull.Value) ? ((long)0) : ((long)(-1));
break;
case 0x27:
num = (obj3 != DBNull.Value) ? ((long)0) : ((long)1);
break;
}
return((int)num);
}
private void Create_DataTable()
{
int iRowCnt = 0;
// CREATE A DATATABLE AND ADD COLUMNS TO IT.
mytable.Columns.Add(new System.Data.DataColumn("اسم الصنف", System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("التاريخ",
System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("العدد", System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("السعر",
System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("الاجمالى",
System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("اجمالى الوارد",
System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("اجمالى المنصرف",
System.Type.GetType("System.String")));
mytable.Columns.Add(new System.Data.DataColumn("الرصيد اليومى/الشهرى",
System.Type.GetType("System.String")));
// REMOVE PAGING TO HELP EXPORT ENTIRE GRIDVIEW TO EXCEL.
if (ViewState["click"].ToString() == "1")
{
ShowDatabyClient();
}
if (ViewState["click"].ToString() == "2")
{
ShowDatabyItem();
}
if (ViewState["click"].ToString() == "3")
{
ShowDatabydate();
}
if (ViewState["click"].ToString() == "4")
{
ShowDatabymonthDate();
}
GridView1.AllowPaging = false;
GridView1.DataBind();
foreach (GridViewRow row in GridView1.Rows)
{
dr = mytable.NewRow();
dr[0] = GridView1.Rows[iRowCnt].Cells[5].Text;
dr[1] = GridView1.Rows[iRowCnt].Cells[6].Text;
dr[2] = GridView1.Rows[iRowCnt].Cells[7].Text;
dr[3] = GridView1.Rows[iRowCnt].Cells[8].Text;
dr[4] = GridView1.Rows[iRowCnt].Cells[9].Text;
dr[5] = GridView1.Rows[iRowCnt].Cells[10].Text;
mytable.Rows.Add(dr);
iRowCnt += 1;
}
dr2 = mytable.NewRow();
dr2[0] = "";
dr2[1] = "";
dr2[2] = "";
dr2[3] = "";
dr2[4] = "الاجمالى :" + txtalltotal.Text;
dr2[5] = "اجمالى الوارد :" + txttawtotal.Text;
dr2[6] = "اجمالى المنصرف :" + txtrasedd.Text;
dr2[7] = "الرصيد اليومى/الشهرى :" + txtrasedyomy.Text;
mytable.Rows.Add(dr2);
}
/// <summary>
/// Initialize the supplied row from the persistent fields of this object. Note that the ObjectId is initialized
/// by the PersistenceManager outside of this method.
/// </summary>
/// <param name="pc">Persistence capable object</param>
/// <param name="row">the row that should be filled</param>
/// <param name="fieldNames">A String array with the field names.</param>
/// <remarks>The field names and right order of the names in the array will be listed by the enhancer in the file FieldNames.txt.</remarks>
public static void NDOWrite(object pc, System.Data.DataRow row, string[] fieldNames)
{
((IPersistenceCapable)pc).NDOWrite(row, fieldNames, 0);
}
public static System.Data.DataTable CreateDataSetSnapshotTable2(string name = "DataSetSnapshot")
{
System.Data.DataTable t = new System.Data.DataTable(name);
{
System.Data.DataColumn c = new System.Data.DataColumn( );
c.DataType = typeof(System.String);
c.ColumnName = "DataStore";
t.Columns.Add(c);
}
{
System.Data.DataColumn c = new System.Data.DataColumn( );
c.DataType = typeof(System.Boolean);
c.ColumnName = "IsActive";
t.Columns.Add(c);
}
{
System.Data.DataColumn c = new System.Data.DataColumn( );
c.DataType = typeof(System.Int16);
c.ColumnName = "Type";
t.Columns.Add(c);
}
{
System.Data.DataColumn c = new System.Data.DataColumn( );
c.DataType = typeof(System.String); // typeof( System.DateTime );
c.ColumnName = "TS";
t.Columns.Add(c);
}
{
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "a";
r["IsActive"] = false;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "a";
r["IsActive"] = true;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "a";
r["IsActive"] = true;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "b";
r["IsActive"] = false;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "b";
r["IsActive"] = false;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "b";
r["IsActive"] = false;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
{
System.Data.DataRow r = t.NewRow( );
r["DataStore"] = "b";
r["IsActive"] = true;
r["Type"] = 0;
r["TS"] = System.DateTime.Now.ToString("yyyyMMdd-HHmmss,fffffff");
t.Rows.Add(r);
}
}
return(t);
}
/// <summary>
/// Envia los cambios del tpr_ObjetosCuentasRow a la base de datos realizando una validacin previa. Mtodo Sobrecargado
/// </summary>
public static void UpdateWithValidation(System.Data.DataRow row)
{
UpdateWithValidation((tpr_ObjetosCuentasDataset.tpr_ObjetosCuentasRow)row);
}
public CTaskList getSingleTask_longplan(System.Data.DataRow projectData)
{
if (Organization == "规划室" && userlevel == "6" && projectData["SOLUCHIEF"].ToString() == userName)
{
if (projectData["SOLUCOMPDATE_R"].ToString() == "" || projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["FACTCHECKDATE_R"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "#" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "#" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "#")
{
this.workItem = "进行中";
this.workUrl = "long_plan2.aspx";
}
else if (projectData["SOLUSUBMITDATE"].ToString() != "" && projectData["SOLUCHECKDATE"].ToString() != "" && projectData["SOLUADVICEREPLYDATE"].ToString() != "" && projectData["SOLUAPPROVEDATE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "#")
{
this.workItem = "结束";
this.workUrl = "long_plan2.aspx";
}
else
{
this.workItem = "等待中";
this.workUrl = "long_plan2.aspx";
}
}
else if (Organization == "规划室" && userlevel == "2")
{
if (projectData["SOLUSUBMITDATE"].ToString() == "" || projectData["SOLUCHECKDATE"].ToString() == "" || projectData["SOLUADVICEREPLYDATE"].ToString() == "" || projectData["SOLUAPPROVEDATE"].ToString() == "" || projectData["FINALSOLUTIONFILE"].ToString() == "" || projectData["FINALSOLUTIONFILE"].ToString() == "#")
{
if (projectData["SOLUCOMPDATE_R"].ToString() == "" || projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["FACTCHECKDATE_R"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "#" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "#" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "#")
{
this.workItem = "等待中";
}
else
{
this.workItem = "进行中";
this.workUrl = "long_plan1.aspx";
}
}
else
{
this.workItem = "结束";
this.workUrl = "long_plan1.aspx";
}
}
else if (Organization == "矿区室" && userlevel == "6" && projectData["SOLUCHIEF"].ToString() == userName)
{
if (projectData["SOLUCOMPDATE_R"].ToString() == "" || projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["FACTCHECKDATE_R"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "#" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "#" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "#")
{
this.workItem = "进行中";
this.workUrl = "long_plan2.aspx";
}
else if (projectData["SOLUSUBMITDATE"].ToString() != "" && projectData["SOLUCHECKDATE"].ToString() != "" && projectData["SOLUADVICEREPLYDATE"].ToString() != "" && projectData["SOLUAPPROVEDATE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "#")
{
this.workItem = "结束";
this.workUrl = "long_plan2.aspx";
}
else
{
this.workItem = "等待中";
this.workUrl = "long_plan2.aspx";
}
}
else if (Organization == "矿区室" && userlevel == "2")
{
if (projectData["SOLUSUBMITDATE"].ToString() == "" || projectData["SOLUCHECKDATE"].ToString() == "" || projectData["SOLUADVICEREPLYDATE"].ToString() == "" || projectData["SOLUAPPROVEDATE"].ToString() == "" || projectData["FINALSOLUTIONFILE"].ToString() == "" || projectData["FINALSOLUTIONFILE"].ToString() == "#")
{
if (projectData["SOLUCOMPDATE_R"].ToString() == "" || projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["FACTCHECKDATE_R"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "" || projectData["DRAFTSOLUTIONFILE"].ToString() == "#" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == "#" || projectData["FACTAPPRSOLUTIONFILE"].ToString() == "#")
{
this.workItem = "等待中";
}
else
{
this.workItem = "进行中";
this.workUrl = "long_plan1.aspx";
}
}
else
{
this.workItem = "结束";
this.workUrl = "long_plan1.aspx";
}
}
else
{
if (projectData["SOLUSUBMITDATE"].ToString() != "" && projectData["SOLUCHECKDATE"].ToString() != "" && projectData["SOLUADVICEREPLYDATE"].ToString() != "" && projectData["SOLUAPPROVEDATE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "#")
{
this.workItem = "结束";
}
else
{
this.workItem = "等待中";
}
}
return(this);
}
void ActiveEditor_MouseUp(object sender, MouseEventArgs e)
{
System.Data.DataRow row = gvTheLoai.GetDataRow(gvTheLoai.FocusedRowHandle);
MaTL = row[0].ToString();
TenTL = row[1].ToString();
}
public static RateInfoRow Parse(System.Data.DataRow row)
{
return(new RateInfoCollection(null).MapRow(row));
}
protected override bool DrawBackground(Graphics g, Rectangle bounds, int rowNum, Brush backBrush, System.Data.DataRow dr)
{
Brush background = backBrush; // Use default brush by... hmm... default.
if ((null != this.AltSolidBrush) || (null != this.AltSolidBrushSpec))
{ // If have alternating brush, row is odd and not selected...
bool bSel = (((SolidBrush)backBrush).Color != Owner.SelectionBackColor) ? false : true;
if (bSel == false)
{
if (System.DBNull.Value != dr["DIFF"])
{
NSI.DOCCTRL nState = (NSI.DOCCTRL)dr["DIFF"];
if (
(nState == NSI.DOCCTRL.OK) ||
(((int)dr["MEST"] == (int)dr["MESTZ"]) && ((int)dr["TYPOP"] != AppC.TYPOP_MOVE) && ((int)dr["MEST"] > 0))
)
{
if (this.AltSolidBrush != null)
{
background = this.AltSolidBrush; // Then use alternating brush.
}
}
else
{
if (this.AltSolidBrushSpec != null)
{
if (((System.DBNull.Value != dr["DIFF"]) &&
((NSI.DOCCTRL)dr["DIFF"] == NSI.DOCCTRL.WARNS))
)
{
background = this.AltSolidBrushSpec; // Then use alternating brush.
}
}
}
}
if (System.DBNull.Value != dr["SSCCONLY"])
{
if ((int)dr["SSCCONLY"] > 0)
{// документы для контроля
if (this.AltSolidBrushSpec != null)
{
background = this.AltSolidBrushSpec; // Then use alternating brush.
}
}
}
}
}
g.FillRectangle(background, bounds); // Draw cell background
return(false);
}
protected override bool DrawBackground(Graphics g, Rectangle bounds, int rowNum,
Brush backBrush, System.Data.DataRow dr)
{
Brush background = backBrush;
bool bSelAll = false,
bSel = (((SolidBrush)backBrush).Color != Owner.SelectionBackColor) ? false : true;
if (bSel == false)
{// вообще-то не выделена, но иногда надо выделить
switch (this.TableInd)
{
case NSI.BD_DIND:
if (MainF.drEasyEdit == dr)
{ // режим быстрого ввода
background = this.SelBackBrush;
bSelAll = true;
}
else
{ // возможны и другие цвета
if ((null != this.AltSolidBrush) || (null != this.AltSolidBrushSpec))
{ // If have alternating brush, row is odd and not selected...
if (System.DBNull.Value != dr["READYZ"])
{
NSI.READINESS nState = (NSI.READINESS)dr["READYZ"];
if (nState == NSI.READINESS.FULL_READY)
{
background = this.AltSolidBrush; // Then use alternating brush.
}
else
{
if (this.AltSolidBrushSpec != null)
{
//if ((int)dr["COND"] == (int)NSI.SPECCOND.PARTY_SET)
// background = this.AltSolidBrushSpec; // Then use alternating brush.
if ((((int)dr["COND"] & (int)NSI.SPECCOND.DATE_SET_EXACT) > 0) &&
(this.MappingName == "DVR"))
{
background = this.AltSolidBrushSpec; // Then use alternating brush.
}
}
}
}
if (this.MappingName == "KOLM")
{
background = this.AltSolidBrushSpec; // Then use alternating brush.
}
}
}
break;
case NSI.BD_DOUTD:
if (null != this.AltSolidBrush)
{
//if (( (xF.xCDoc.nTypOp == AppC.TYPOP_PRMK)||(xF.xCDoc.nTypOp == AppC.TYPOP_MARK))
if ((xF.xCDoc.xDocP.nTypD == AppC.TYPD_OPR) &&
(this.MappingName == "SNM"))
{
if (((int)dr["STATE"] & (int)AppC.OPR_STATE.OPR_TRANSFERED) > 0)
{
background = this.AltSolidBrush;
}
}
else
{
if (dr.GetChildRows(NSI.REL2BRK).Length > 0)
{
//if (this.MappingName == "KOLE")
background = this.AltSolidBrush; // Для строк с браком
}
}
}
if (null != this.AltSolidBrushSpec)
{
if (((int)dr["NPODDZ"] < 0) &&
(this.MappingName == "KOLE"))
{
background = this.AltSolidBrushSpec;
}
}
break;
}
//if (this.TableInd == NSI.BD_DIND)
//{// колонка для заявок
// if (MainF.drEasyEdit == dr)
// {// режим быстрого ввода
// background = this.SelBackBrush;
// bSelAll = true;
// }
// else
// {// возможны и другие цвета
// if ((null != this.AltSolidBrush) || (null != this.AltSolidBrushSpec))
// { // If have alternating brush, row is odd and not selected...
// if ((bSel == false) && (System.DBNull.Value != dr["READYZ"]))
// {
// NSI.READINESS nState = (NSI.READINESS)dr["READYZ"];
// if (nState == NSI.READINESS.FULL_READY)
// background = this.AltSolidBrush; // Then use alternating brush.
// else
// {
// if (this.AltSolidBrushSpec != null)
// {
// if (((System.DBNull.Value != dr["NP"]) && ((int)dr["NP"] > 0)))
// background = this.AltSolidBrushSpec; // Then use alternating brush.
// }
// }
// }
// }
// }
//}
}
g.FillRectangle(background, bounds);
return(bSelAll);
}
/// <summary>
/// This method sets a new value for the specified column for the DataRow it’s called on.
/// </summary>
/// <param name="row">
/// The input DataRow.
/// </param>
/// <param name="column">
/// The input DataColumn specificy which row value to retrieve.
/// </param>
/// <param name="value">
/// The new row value for the specified column.
/// </param>
public static void SetField <T>(this DataRow row, DataColumn column, T value)
{
DataSetUtil.CheckArgumentNull(row, "row");
row[column] = (object)value ?? DBNull.Value;
}
/// <summary>
/// This method provides access to the values in each of the columns in a given row.
/// This method makes casts unnecessary when accessing columns.
/// Additionally, Field supports nullable types and maps automatically between DBNull and
/// Nullable when the generic type is nullable.
/// </summary>
/// <param name="row">
/// The input DataRow
/// </param>
/// <param name="columnName">
/// The input column name specificy which row value to retrieve.
/// </param>
/// <returns>
/// The DataRow value for the column specified.
/// </returns>
public static T Field <T>(this DataRow row, string columnName)
{
DataSetUtil.CheckArgumentNull(row, "row");
return(UnboxT <T> .Unbox(row[columnName]));
}
/// <summary>
/// 获取编号
/// </summary>
/// <param name="dt"></param>
/// <param name="name"></param>
private string name2ID(DataTable dt, string value, string column)
{
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns[column] };
System.Data.DataRow row = dt.Rows.Find(value);
return(row.ItemArray[1].ToString());
}
void IptBaseDb.CreateParam(System.Data.IDbCommand cmd, System.Data.DataTable dtParam, System.Data.DataRow rowValue)
{
throw new NotImplementedException();
}
private void gridView1_HiddenEditor(object sender, EventArgs e)
{
try
{
int slno = gridView1.GetFocusedDataSourceRowIndex();
Test.Purchase.database.PurchaseOrder po = new Purchase.database.PurchaseOrder();
System.Data.DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
row["slno"] = (slno + 1) + "";
if (gridView1.FocusedColumn.FieldName.Equals("itemCode"))
{
String itemcode = row["itemCode"].ToString();
if (itemcode != "")
{
po.FnConn();
DataTable dt = po.FillData("itemdetails", itemcode);
if (dt.Rows.Count > 0)
{
row["description"] = dt.Rows[0]["itemName"].ToString();
row["brand"] = dt.Rows[0]["brandName"].ToString();
row["quantity"] = "1";
}
}
}
if (gridView1.FocusedColumn.FieldName.Equals("quantity"))
{
double quantity = 0, unitprice = 0;
try
{
quantity = Convert.ToDouble(row["quantity"] + "");
}
catch (Exception ex1)
{
row["quantity"] = "1";
}
try
{
unitprice = Convert.ToDouble(row["unitprice"] + "");
}
catch (Exception invalidstring)
{
row["unitprice"] = "";
}
double total = quantity * unitprice;
row["amount"] = total + "";
row["total"] = total + "";
int index = gridView1.GetFocusedDataSourceRowIndex();
gridView1.RefreshRow(index);
calculateTotal();
gridView1.FocusedColumn = gridView1.GetVisibleColumn(6);
gridView1.FocusedRowHandle = index;
gridView1.ShowEditor();
}
if (gridView1.FocusedColumn.FieldName.Equals("unitprice"))
{
double quantity = 0, unitprice = 0;
try
{
quantity = Convert.ToDouble(row["quantity"] + "");
}
catch (Exception ex1)
{
row["quantity"] = "1";
}
try
{
unitprice = Convert.ToDouble(row["unitprice"] + "");
}
catch (Exception invalidstring)
{
row["unitprice"] = "";
}
double total = quantity * unitprice;
row["amount"] = total + "";
row["total"] = total + "";
int index = gridView1.GetFocusedDataSourceRowIndex();
gridView1.RefreshRow(index);
calculateTotal();
gridView1.FocusedColumn = gridView1.GetVisibleColumn(6);
gridView1.FocusedRowHandle = index;
gridView1.ShowEditor();
}
}
catch (Exception)
{
}
}
protected override void FillProps(System.Data.DataRow in_row)
{
base.FillProps(in_row);
CellsXAsString = (string)in_row["cells_x"];
CellsYAsString = (string)in_row["cells_y"];
}
/// <summary>
/// Envia los cambios del tpu_ComprobantesPagoRow a la base de datos realizando una validacin previa. Mtodo Sobrecargado
/// </summary>
public static void UpdateWithValidation(System.Data.DataRow row)
{
UpdateWithValidation((tpu_ComprobantesPagoDataset.tpu_ComprobantesPagoRow)row);
}
/// <summary>
/// Envia los cambios del tsa_ComprobantesMovimientosDeStockRow a la base de datos realizando una validacin previa. Mtodo Sobrecargado
/// </summary>
public static void UpdateWithValidation(System.Data.DataRow row)
{
UpdateWithValidation((tsa_ComprobantesMovimientosDeStockDataset.tsa_ComprobantesMovimientosDeStockRow)row);
}
/// <summary>
/// Envia los cambios del st_TareaRow a la base de datos realizando una validacin previa. Mtodo Sobrecargado
/// </summary>
public static void UpdateWithValidation(System.Data.DataRow row)
{
UpdateWithValidation((st_TareaDataset.st_TareaRow)row);
}
public static void LoadDataStoreSnapshotFilesTable(System.Data.DataSet ds)
{
DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection("DataPhilosophiaeSection") as DataPhilosophiaeSection;
System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
if (dps == null)
{
throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
}
if (css == null)
{
throw new System.Exception("[connectionStrings] section missing in app.config!!!");
}
int iii = 0;
DataTable dscTbl = ds.Tables[DataStoreConfig_TblName];
DataTable dsssfTbl = ds.Tables[DataStoreSnapshotFile_TblName];
foreach (DataStoreElement dse in dps.DataStores)
{
System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
{
System.Data.DataRow r = dscTbl.NewRow( );
//r[ "ID" ] = i++;
r["Name"] = dse.Name;
r["ConnectionStringName"] = dse.ConnectionStringName;
r["LoadDefaultDatabaseOnly"] = dse.LoadDefaultDatabaseOnly == 1 ? true : false;
r["LoadSystemObjects"] = dse.LoadSystemObjects == 1 ? true : false;
r["WithFields"] = dse.WithFields == 1 ? true : false;
r["StagePathDir"] = string.IsNullOrWhiteSpace(dse.PathDir)
? System.IO.Path.Combine(dps.Stage.PathDir, dse.Name)
: dse.PathDir;
r["ConnectionString"] = cs != null ? cs.ConnectionString : null;
r["ProviderName"] = cs != null ? cs.ProviderName : null;
//
System.IO.DirectoryInfo di = new System.IO.DirectoryInfo((string)r["StagePathDir"]);
r[IsValidStagePathDir_ColName] = di.Exists;
r["IsValidProviderName"] = !string.IsNullOrWhiteSpace(cs != null ? cs.ProviderName : null);
//
dscTbl.Rows.Add(r);
//
if (di.Exists)
{
System.IO.FileInfo[] files = GetFiles(di);
int ii = 0;
for (int i = 0; i < files.Length; i++)
{
System.Data.DataRow rr = dsssfTbl.NewRow( );
rr["Name"] = dse.Name;
rr["IsActive"] = false;
rr["LastWriteTimeUtc"] = files[i].LastWriteTimeUtc;
if (files[i].LastWriteTimeUtc > files[ii].LastWriteTimeUtc)
{
ii = i;
}
rr["SnapshotFile"] = files[i];
dsssfTbl.Rows.Add(rr);
}
if (files.Length > 0)
{
dsssfTbl.Rows[iii + ii]["IsActive"] = true;
}
iii += files.Length;
}
}
}
}
/// <summary>
/// Envia los cambios del tsh_AgrupProductosRow a la base de datos realizando una validacin previa. Mtodo Sobrecargado
/// </summary>
public static bool UpdateWithValidation(System.Data.DataRow row)
{
return(UpdateWithValidation((tsh_AgrupProductosDataset.tsh_AgrupProductosRow)row));
}
public static CustomerSupportGroupRow Parse(System.Data.DataRow row)
{
return(new CustomerSupportGroupCollection(null).MapRow(row));
}
private void btnedtSou_TextChanged(object sender, EventArgs e)
{
if (btnedtSou.Text == "")
{
return;
}
string[] sPosPairs = System.IO.File.ReadAllLines(btnedtSou.Text);
if (sPosPairs == null || sPosPairs.Length == 0)
{
MessageBox.Show("请选择正确的文件");
return;
}
int startIndex = 0;
if (chkBegin2.Checked)
{
startIndex = 1;
}
if (sPosPairs.Length <= startIndex)
{
MessageBox.Show("请选择正确的文件");
return;
}
int ixh = GetMaxXH() + 1;
DataTable dt = this.treePosPair.DataSource as DataTable;
double soux, souy, souz, tarx, tary, tarz;
int errCount = 0;
for (int i = startIndex; i < sPosPairs.Length; i++)
{
souz = 0;
tarz = 0;
try
{
string[] parts = sPosPairs[i].Split(',');
soux = Convert.ToDouble(parts[1]);
souy = Convert.ToDouble(parts[2]);
if (chkHavZ.Checked)
{
souz = Convert.ToDouble(parts[3]);
tarx = Convert.ToDouble(parts[4]);
tary = Convert.ToDouble(parts[5]);
tarz = Convert.ToDouble(parts[6]);
}
else
{
tarx = Convert.ToDouble(parts[3]);
tary = Convert.ToDouble(parts[4]);
}
}
catch
{
errCount++;
continue;
}
System.Data.DataRow row = dt.NewRow();
row.SetField("I_XH", ixh++);
row.SetField("WKID", this._wkid);
row.SetField("SOU_X", soux);
row.SetField("SOU_Y", souy);
row.SetField("SOU_Z", souz);
row.SetField("TAR_X", tarx);
row.SetField("TAR_Y", tary);
row.SetField("TAR_Z", tarz);
dt.Rows.Add(row);
}
if (errCount == 0 || DialogResult.OK == MessageBox.Show(string.Format("总计{0}条记录，其中无效记录{1}条,\r\n是否继续添加？点击“OK”，则继续添加，否则不添加。", sPosPairs.Length - startIndex, errCount), "提示", MessageBoxButtons.OKCancel))
{
this.treePosPair.DataSource = dt;
this.treePosPair.RefreshDataSource();
}
else
{
this.btnedtSou.Text = "";
}
}
public int Compare(System.Data.DataRow x, System.Data.DataRow y)
{
int compareResult = 0;
foreach (int key in SortColumns.Keys)
{
string value1 = string.Empty;
string value2 = string.Empty;
//int compareResult;
// Check for nulls
if (x.ItemArray[key] == DBNull.Value)
{
value1 = "0";
}
else
{
value1 = x.ItemArray[key].ToString().TrimEnd('+');
if (value1.Contains('.'))
{
value1 = value1.TrimStart('.');
}
if (value1.Contains('床'))
{
value1.Replace("床", "");
}
value1 = value1.TrimStart('+');
}
if (y.ItemArray[key] == DBNull.Value)
{
value2 = "0";
}
else
{
value2 = y.ItemArray[key].ToString().TrimEnd('+');
if (value2.Contains('.'))
{
value2 = value2.TrimStart('.');
}
if (value2.Contains('床'))
{
value2.Replace("床", "");
}
value2 = value2.TrimStart('+');
}
if (IsNumeric(value1) && IsNumeric(value2))
{
if (int.Parse(value1) > int.Parse(value2))
{
compareResult = 1;
}
else if (int.Parse(value1) < int.Parse(value2))
{
compareResult = -1;
}
else
{
compareResult = 0;
}
}
else if (IsNumeric(value1))
{
compareResult = -1;
}
else if (IsNumeric(value2))
{
compareResult = 1;
}
else
{
compareResult = System.String.Compare(value1, value2);
}
}
return(compareResult * sortOrderModifier);
}
internal static DataTable GetSchemaTableFromDataTable(DataTable table)
{
if (table == null)
{
throw ExceptionBuilder.ArgumentNull(nameof(DataTable));
}
DataTable tempSchemaTable = new DataTable("SchemaTable");
tempSchemaTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
DataColumn ColumnName = new DataColumn(SchemaTableColumn.ColumnName, typeof(string));
DataColumn ColumnOrdinal = new DataColumn(SchemaTableColumn.ColumnOrdinal, typeof(int));
DataColumn ColumnSize = new DataColumn(SchemaTableColumn.ColumnSize, typeof(int));
DataColumn NumericPrecision = new DataColumn(SchemaTableColumn.NumericPrecision, typeof(short));
DataColumn NumericScale = new DataColumn(SchemaTableColumn.NumericScale, typeof(short));
DataColumn DataType = new DataColumn(SchemaTableColumn.DataType, typeof(Type));
DataColumn ProviderType = new DataColumn(SchemaTableColumn.ProviderType, typeof(int));
DataColumn IsLong = new DataColumn(SchemaTableColumn.IsLong, typeof(bool));
DataColumn AllowDBNull = new DataColumn(SchemaTableColumn.AllowDBNull, typeof(bool));
DataColumn IsReadOnly = new DataColumn(SchemaTableOptionalColumn.IsReadOnly, typeof(bool));
DataColumn IsRowVersion = new DataColumn(SchemaTableOptionalColumn.IsRowVersion, typeof(bool));
DataColumn IsUnique = new DataColumn(SchemaTableColumn.IsUnique, typeof(bool));
DataColumn IsKeyColumn = new DataColumn(SchemaTableColumn.IsKey, typeof(bool));
DataColumn IsAutoIncrement = new DataColumn(SchemaTableOptionalColumn.IsAutoIncrement, typeof(bool));
DataColumn BaseSchemaName = new DataColumn(SchemaTableColumn.BaseSchemaName, typeof(string));
DataColumn BaseCatalogName = new DataColumn(SchemaTableOptionalColumn.BaseCatalogName, typeof(string));
DataColumn BaseTableName = new DataColumn(SchemaTableColumn.BaseTableName, typeof(string));
DataColumn BaseColumnName = new DataColumn(SchemaTableColumn.BaseColumnName, typeof(string));
DataColumn AutoIncrementSeed = new DataColumn(SchemaTableOptionalColumn.AutoIncrementSeed, typeof(long));
DataColumn AutoIncrementStep = new DataColumn(SchemaTableOptionalColumn.AutoIncrementStep, typeof(long));
DataColumn DefaultValue = new DataColumn(SchemaTableOptionalColumn.DefaultValue, typeof(object));
DataColumn Expression = new DataColumn(SchemaTableOptionalColumn.Expression, typeof(string));
DataColumn ColumnMapping = new DataColumn(SchemaTableOptionalColumn.ColumnMapping, typeof(MappingType));
DataColumn BaseTableNamespace = new DataColumn(SchemaTableOptionalColumn.BaseTableNamespace, typeof(string));
DataColumn BaseColumnNamespace = new DataColumn(SchemaTableOptionalColumn.BaseColumnNamespace, typeof(string));
ColumnSize.DefaultValue = -1;
if (table.DataSet != null)
{
BaseCatalogName.DefaultValue = table.DataSet.DataSetName;
}
BaseTableName.DefaultValue = table.TableName;
BaseTableNamespace.DefaultValue = table.Namespace;
IsRowVersion.DefaultValue = false;
IsLong.DefaultValue = false;
IsReadOnly.DefaultValue = false;
IsKeyColumn.DefaultValue = false;
IsAutoIncrement.DefaultValue = false;
AutoIncrementSeed.DefaultValue = 0;
AutoIncrementStep.DefaultValue = 1;
tempSchemaTable.Columns.Add(ColumnName);
tempSchemaTable.Columns.Add(ColumnOrdinal);
tempSchemaTable.Columns.Add(ColumnSize);
tempSchemaTable.Columns.Add(NumericPrecision);
tempSchemaTable.Columns.Add(NumericScale);
tempSchemaTable.Columns.Add(DataType);
tempSchemaTable.Columns.Add(ProviderType);
tempSchemaTable.Columns.Add(IsLong);
tempSchemaTable.Columns.Add(AllowDBNull);
tempSchemaTable.Columns.Add(IsReadOnly);
tempSchemaTable.Columns.Add(IsRowVersion);
tempSchemaTable.Columns.Add(IsUnique);
tempSchemaTable.Columns.Add(IsKeyColumn);
tempSchemaTable.Columns.Add(IsAutoIncrement);
tempSchemaTable.Columns.Add(BaseCatalogName);
tempSchemaTable.Columns.Add(BaseSchemaName);
// specific to datatablereader
tempSchemaTable.Columns.Add(BaseTableName);
tempSchemaTable.Columns.Add(BaseColumnName);
tempSchemaTable.Columns.Add(AutoIncrementSeed);
tempSchemaTable.Columns.Add(AutoIncrementStep);
tempSchemaTable.Columns.Add(DefaultValue);
tempSchemaTable.Columns.Add(Expression);
tempSchemaTable.Columns.Add(ColumnMapping);
tempSchemaTable.Columns.Add(BaseTableNamespace);
tempSchemaTable.Columns.Add(BaseColumnNamespace);
foreach (DataColumn dc in table.Columns)
{
DataRow dr = tempSchemaTable.NewRow();
dr[ColumnName] = dc.ColumnName;
dr[ColumnOrdinal] = dc.Ordinal;
dr[DataType] = dc.DataType;
if (dc.DataType == typeof(string))
{
dr[ColumnSize] = dc.MaxLength;
}
dr[AllowDBNull] = dc.AllowDBNull;
dr[IsReadOnly] = dc.ReadOnly;
dr[IsUnique] = dc.Unique;
if (dc.AutoIncrement)
{
dr[IsAutoIncrement] = true;
dr[AutoIncrementSeed] = dc.AutoIncrementSeed;
dr[AutoIncrementStep] = dc.AutoIncrementStep;
}
if (dc.DefaultValue != DBNull.Value)
{
dr[DefaultValue] = dc.DefaultValue;
}
if (dc.Expression.Length != 0)
{
bool hasExternalDependency = false;
DataColumn[] dependency = dc.DataExpression.GetDependency();
for (int j = 0; j < dependency.Length; j++)
{
if (dependency[j].Table != table)
{
hasExternalDependency = true;
break;
}
}
if (!hasExternalDependency)
{
dr[Expression] = dc.Expression;
}
}
dr[ColumnMapping] = dc.ColumnMapping;
dr[BaseColumnName] = dc.ColumnName;
dr[BaseColumnNamespace] = dc.Namespace;
tempSchemaTable.Rows.Add(dr);
}
foreach (DataColumn key in table.PrimaryKey)
{
tempSchemaTable.Rows[key.Ordinal][IsKeyColumn] = true;
}
tempSchemaTable.AcceptChanges();
return(tempSchemaTable);
}
public CTaskList getSingleTask(System.Data.DataRow projectData)
{
if (projectData["BLUEGRAPHARRIVALDATE"].ToString() != "" && projectData["SOLUAPPROVEDATE"].ToString() != "" && projectData["PNUMBER"].ToString() != "" && projectData["PLANINVESMENT"].ToString() != "")
{
this.workItem = "结束";
}
else if (userlevel == "2" && Organization == "规划室") //规划室主任
{
if (projectData["PLANFLAG"].ToString() != "2")
{
if (projectData["SOLUCOMPDATE_P"].ToString() != "" && projectData["SOLUCOMPDATE_R"].ToString() == "")//如果方案计划完成时间不为空，方案实际完成时间为空，则应该编写方案
{
this.workItem = "等待中";
this.workUrl = "init_planRun_dtz.aspx";
}
else if (projectData["INSTAPPRSOLUTIONFILE"].ToString() != "" && (projectData["DESICONDITIONTABLE"].ToString() == "" || projectData["SOLUAPPROVEDATE"].ToString() == "" || projectData["PNUMBER"].ToString() == "" || projectData["PLANINVESMENT"].ToString() == ""))
{
this.workItem = "上报方案";
this.workUrl = "planrun_part.aspx";
}
else if (projectData["PLANFLAG"].ToString() == "1" && (projectData["SOLUAPPROVEDATE"].ToString() == "" || projectData["PNUMBER"].ToString() == "" || projectData["PLANINVESMENT"].ToString() == ""))
{
this.workItem = "上报方案";
this.workUrl = "write_planrun_free.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "2" && Organization == "矿区室") //矿区室主任
{
//矿区室进行规划
if (projectData["PLANFLAG"].ToString() == "2")
{
if (projectData["SOLUCOMPDATE_P"].ToString() != "" && projectData["SOLUCOMPDATE_R"].ToString() == "")//如果方案计划完成时间不为空，方案实际完成时间为空，则应该编写方案
{
this.workItem = "等待中";
this.workUrl = "init_planRun_dtz.aspx";
}
else if (projectData["INSTAPPRSOLUTIONFILE"].ToString() != "" && (projectData["DESICONDITIONTABLE"].ToString() == "" || projectData["SOLUAPPROVEDATE"].ToString() == "" || projectData["PNUMBER"].ToString() == "" || projectData["PLANINVESMENT"].ToString() == ""))
{
this.workItem = "上报方案";
this.workUrl = "planrun_part.aspx";
}
else
{
this.workItem = "等待中";
}
}
//矿区室进行设计
else if (projectData["PLANFLAG_DESIGN"].ToString() == "1")
{
if (projectData["DESICONDITIONTABLE"].ToString() != "" && projectData["PNUMBER"].ToString() != "" && projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["DESICHIEF"].ToString() == "" && projectData["MAJORPROOFREADER"].ToString() == "")
{
this.workItem = "指定负责人";
this.workUrl = "DesignatedDesignPerson.aspx";
}
else if ((projectData["DESICHIEF"].ToString() != "" || projectData["MAJORPROOFREADER"].ToString() != "") && projectData["MAJORDELEGATEDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DesignatedDesignPerson.aspx";
}
else if (projectData["INITIALDESISUBMITDATE_R"].ToString() != "" && (projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() == "" || projectData["DESIAPPRFILE"].ToString() == ""))
{
this.workItem = "批复下达";
this.workUrl = "DesiApprovalArrival.aspx";
}
else if (projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() != "" && projectData["DESIAPPRFILE"].ToString() != "" && projectData["BUDGETADJUSTDATE_P"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DesiApprovalArrival.aspx";
}
else if (projectData["BUDGETADJUSTDATE_R"].ToString() != "" && (projectData["PLANARRIVALFILENUMBER"].ToString() == "" || projectData["PLANARRIVALFILE"].ToString() == ""))
{
this.workItem = "计划下达";
this.workUrl = "PlanArrival.aspx";
}
else if (projectData["PLANARRIVALFILENUMBER"].ToString() != "" && projectData["PLANARRIVALFILE"].ToString() != "" && projectData["WHITEGRAPHCHECKDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "PlanArrival.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
}
else if (userName == projectData["SOLUCHIEF"].ToString()) //方案负责人
{
if (projectData["SOLUCOMPDATE_P"].ToString() != "" && projectData["SOLUCOMPDATE_R"].ToString() == "") //如果方案计划完成时间不为空，方案实际完成时间为空，则应该编写方案
{
this.workItem = "编写方案";
this.workUrl = "writePlan.aspx";
}
else if (projectData["CHECKSTATE"].ToString() == "0")
{
this.workItem = "重写方案";
this.workUrl = "planReturn.aspx";
}
else if (projectData["CHECKSTATE"].ToString() == "")//所审还没进行之前，可以修改之前上传的表单
{
this.workItem = "等待中";
this.workUrl = "writePlan.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "4" && Organization == "规划室") //如果所审计划时间确定、方案实际完成时间确定且实际所审时间还未确定，则应该进行实际所审。
{
if (projectData["PLANFLAG"].ToString() != "2")
{
if (projectData["CHECKSTATE"].ToString() == "" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && (projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == ""))
{
this.workItem = "审查方案";
this.workUrl = "CheckPlanRun_dtz.aspx";
}
else if (projectData["CHECKSTATE"].ToString() == "0" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && projectData["INSTAPPRSOLUTIONFILE"].ToString() == "")
{
this.workItem = "退回方案";
}
else if (projectData["CHECKSTATE"].ToString() == "1" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && projectData["INSTAPPRSOLUTIONFILE"].ToString() == "")
{
this.workItem = "重新审查方案";
this.workUrl = "CheckPlanRun_dtz.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "4" && Organization == "矿区室") //如果所审计划时间确定、方案实际完成时间确定且实际所审时间还未确定，则应该进行实际所审。
{
if (projectData["PLANFLAG"].ToString() == "2")
{
if (projectData["CHECKSTATE"].ToString() == "" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && (projectData["INSTCHECKDATE_R"].ToString() == "" || projectData["INSTAPPRSOLUTIONFILE"].ToString() == ""))
{
this.workItem = "审查方案";
this.workUrl = "CheckPlanRun_dtz.aspx";
}
else if (projectData["CHECKSTATE"].ToString() == "0" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && projectData["INSTAPPRSOLUTIONFILE"].ToString() == "")
{
this.workItem = "退回方案";
}
else if (projectData["CHECKSTATE"].ToString() == "1" && projectData["SOLUCOMPDATE_R"].ToString() != "" && projectData["INSTCHECKDATE_P"].ToString() != "" && projectData["INSTAPPRSOLUTIONFILE"].ToString() == "")
{
this.workItem = "重新审查方案";
this.workUrl = "CheckPlanRun_dtz.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "2" && Organization == "设计室") //设计室主任
{
if (projectData["PLANFLAG_DESIGN"].ToString() == "0")
{
//if (projectData["PLANFLAG"].ToString() == "1" && (projectData["SOLUCOMPDATE_P"].ToString() == "" || projectData["DESICHIEF"].ToString() == ""))//如果方案计划完成时间不为空，方案实际完成时间为空，则应该编写方案
//{
// this.workItem = "发起流程";
// this.workUrl = "init_planRun_free.aspx";
//}
//if (projectData["PLANFLAG"].ToString() == "1" && projectData["WORKLOADSUBMITDATE_P"].ToString() != "" && projectData["DESICHIEF"].ToString() != "" && projectData["SOLUCOMPDATE_R"].ToString() == "")//如果方案计划完成时间不为空，方案实际完成时间为空，则应该编写方案
//{
// this.workItem = "等待中";
// this.workUrl = "init_planRun_free.aspx";
//}
if ((projectData["PLANFLAG"].ToString() == "0" || projectData["PLANFLAG"].ToString() == "2") && projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["PNUMBER"].ToString() != "" && projectData["DESICONDITIONTABLE"].ToString() != "" && (projectData["DESICHIEF"].ToString() == "" || projectData["MAJORPROOFREADER"].ToString() == ""))
{
this.workItem = "指定负责人";
this.workUrl = "DesignatedDesignPerson.aspx";
}
else if ((projectData["PLANFLAG"].ToString() == "0" || projectData["PLANFLAG"].ToString() == "2") && projectData["DESICHIEF"].ToString() != "" && projectData["MAJORPROOFREADER"].ToString() != "" && projectData["WORKLOADSUBMITDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DesignatedDesignPerson.aspx";
}
else if (projectData["INITIALDESISUBMITDATE_R"].ToString() != "" && (projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() == "" || projectData["DESIAPPRFILE"].ToString() == ""))
{
this.workItem = "批复下达";
this.workUrl = "DesiApprovalArrival.aspx";
}
else if (projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() != "" && projectData["DESIAPPRFILE"].ToString() != "" && projectData["BUDGETADJUSTDATE_P"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DesiApprovalArrival.aspx";
}
else if (projectData["BUDGETADJUSTDATE_R"].ToString() != "" && (projectData["PLANARRIVALFILENUMBER"].ToString() == "" || projectData["PLANARRIVALFILE"].ToString() == ""))
{
this.workItem = "计划下达";
this.workUrl = "PlanArrival.aspx";
}
else if (projectData["PLANARRIVALFILENUMBER"].ToString() != "" && projectData["PLANARRIVALFILE"].ToString() != "" && projectData["WHITEGRAPHCHECKDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "PlanArrival.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "2" && Organization == "综合室") //综合室主任
{
if (projectData["PLANFLAG"].ToString() == "1" && projectData["BUDGETCHIEF"].ToString() == "")
{
this.workItem = "指定概算负责人";
this.workUrl = "DesignatedBudgetPerson.aspx";
}
else if (projectData["FINALSOLUTIONFILE"].ToString() != "" && projectData["PNUMBER"].ToString() != "" && projectData["DESICONDITIONTABLE"].ToString() != "" && projectData["BUDGETCHIEF"].ToString() == "")
{
this.workItem = "指定概算负责人";
this.workUrl = "DesignatedBudgetPerson.aspx";
}
else if (projectData["BUDGETCHIEF"].ToString() != "" && projectData["BUDGETCOMPDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DesignatedBudgetPerson.aspx";
}
else if (projectData["BUDGETCOMPDATE_R"].ToString() != "" && projectData["INITIALDESISUBMITDATE_R"].ToString() == "")
{
this.workItem = "初设上报";
this.workUrl = "InitialDesiSubmit.aspx";
}
else if (projectData["INITIALDESISUBMITDATE_R"].ToString() != "" && projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "InitialDesiSubmit.aspx";
}
else if (projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() != "" && projectData["DESIAPPRFILE"].ToString() != "" && projectData["BUDGETADJUSTDATE_P"].ToString() == "")
{
this.workItem = "概算计划调整时间";
this.workUrl = "BudgetAjustDate_P.aspx";
}
else if (projectData["BUDGETADJUSTDATE_P"].ToString() != "" && projectData["BUDGETADJUSTDATE_R"].ToString() == "")
{
this.workItem = "概算调整";
this.workUrl = "BudgetAdjust.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userName == projectData["DESICHIEF"].ToString())//设计负责人
{
//if(projectData["WORKLOADSUBMITDATE_R"].ToString() == ""&& projectData["PLANFLAG"].ToString() == "1")
//{
// this.workItem = "初设工程量提交";
// this.workUrl = "MajorDelegateData_free.aspx";
//}
if (projectData["DESICHIEF"].ToString() != "" && projectData["WORKLOADSUBMITDATE_R"].ToString() == "")
{
this.workItem = "委托资料和工程量";
this.workUrl = "MainOfCommissionAndWorkload.aspx";
}
else if (projectData["PLANARRIVALFILENUMBER"].ToString() != "" && (projectData["WHITEGRAPHCHECKDATE_R"].ToString() == "" || projectData["BLUEGRAPHDOCUMENT_R"].ToString() == "" || projectData["SECONDCOMMISSIONDATE"].ToString() == ""))
{
this.workItem = "施工白图校审和蓝图";
this.workUrl = "MainOfWhiteGraphAndBlueGraph.aspx";
}
else if (projectData["BLUEGRAPHDOCUMENT_R"].ToString() != "" && projectData["WHITEGRAPHCHECKDATE_R"].ToString() != "" && projectData["SECONDCOMMISSIONDATE"].ToString() != "" && projectData["BLUEGRAPHARRIVALDATE"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "MainOfWhiteGraphAndBlueGraph.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userName == projectData["BUDGETCHIEF"].ToString()) //综合室概算负责人
{
if (projectData["BUDGETCOMPDATE_R"].ToString() == "")
{
this.workItem = "编写概算文档";
this.workUrl = "DraftBudgetFile.aspx";
}
else if (projectData["BUDGETCOMPDATE_R"].ToString() != "" && projectData["INITIALDESISUBMITDATE_R"].ToString() == "")
{
this.workItem = "等待中";
this.workUrl = "DraftBudgetFile.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "6" && (Organization == "设计室" || Organization == "矿区室"))//设计室各专业
{
if (JudgeName(userName, projectData["PNAME"].ToString(), projectData["PNUMBER"].ToString()) == 1 && projectData["WORKLOADSUBMITDATE_R"].ToString() == "")
{
this.workItem = "工程量提交 ";
this.workUrl = "SubmitWorkLoad.aspx";
}
else if (JudgeName(userName, projectData["PNAME"].ToString(), projectData["PNUMBER"].ToString()) == 1 && projectData["DESIAPPROVALARRIVALDATE"].ToString() != "" && projectData["DESIAPPROVALARRIVALFILENUMBER"].ToString() != "" && projectData["SECONDCOMMISSIONDATE"].ToString() == "")
{
this.workItem = "提交二次委托 ";
this.workUrl = "ShowSecComFile.aspx";
}
else if (JudgeName(userName, projectData["PNAME"].ToString(), projectData["PNUMBER"].ToString()) == 1 && projectData["WHITEGRAPHCHECKDATE_R"].ToString() != "" && projectData["BLUEGRAPHDOCUMENT_R"].ToString() == "")
{
this.workItem = "上传蓝图 ";
this.workUrl = "SubmitBlueGraph.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "8" && Organization == "综合室")//综合室图纸管理人
{
if (projectData["BLUEGRAPHDOCUMENT_R"].ToString() != "" && projectData["BLUEGRAPHARRIVALDATE"].ToString() == "")
{
this.workItem = "下发蓝图，记录时间";
this.workUrl = "BlueGraphArrival.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
return(this);
}
public CTaskList getSingleTask_bdtz(System.Data.DataRow projectData)
{
if (projectData["BLUEGRAPHARRIVALDATE"].ToString() != "")
{
this.workItem = "结束";
}
else if (userlevel == "2" && Organization == "规划室")
{
if (projectData["YCZLSubmitDate"].ToString() == "" || projectData["CYZLSubmitDate"].ToString() == "" || projectData["DMZLDelegateDate"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = "ghs0_Datasubmit.aspx";
}
else if (projectData["SoluCompDate_P"].ToString() == "" || projectData["SoluCheckDate_P"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = "ghs4_Datasubmit.aspx";
}
else if (projectData["SOLUCOMPDATE_R"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = "ghs1_Datasubmit.aspx";
}
else if (projectData["SOLUCHECKDATE_R"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = "ghs2_Datasubmit.aspx";
}
else if (projectData["DESISUBMITDATE"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = "ghs3_Datasubmit.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "2" && Organization == "设计室")
{
if (projectData["INITIALDESISUBMITDATE_P"].ToString() == "" || projectData["BLUEGRAPHDOCUMENT_P"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = " DesignGraphDate.aspx";
}
else if (projectData["INITIALDESISUBMITDATE_R"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = " DesignFile.aspx";
}
else if (projectData["BLUEGRAPHDOCUMENT_R"].ToString() == "")
{
this.workItem = "进行中";
this.workUrl = " GraphFile.aspx";
}
else
{
this.workItem = "等待中";
}
}
else if (userlevel == "8" && Organization == "综合室")//综合室图纸管理人
{
if (projectData["BLUEGRAPHDOCUMENT_R"].ToString() != "" && projectData["BLUEGRAPHARRIVALDATE"].ToString() == "")
{
this.workItem = "下发蓝图，记录时间";
this.workUrl = "BlueGraphArrival.aspx";
}
else
{
this.workItem = "等待中";
}
}
else
{
this.workItem = "等待中";
}
return(this);
}
public void CreatePODetailObject(System.Data.DataRow drow)
{
try
{
if (drow.Table.Columns.Contains(CON_FIELD_AMENDMENTNO))
{
this.AmendmentNo = Convert.ToInt32(drow[CON_FIELD_AMENDMENTNO]);
}
if (drow.Table.Columns.Contains(CON_FIELD_CREATEDBY))
{
this.CreatedBy = Convert.ToInt32(drow[CON_FIELD_CREATEDBY]);
}
if (drow.Table.Columns.Contains(CON_FIELD_CREATEDDATE))
{
this.CreatedDate = Convert.ToDateTime(drow[CON_FIELD_CREATEDDATE]);
}
if (drow.Table.Columns.Contains(CON_FIELD_ITEMDESC))
{
this.ItemDescription = Convert.ToString(drow[CON_FIELD_ITEMDESC]);
}
if (drow.Table.Columns.Contains(CON_FIELD_ITEMID))
{
this.ItemID = Convert.ToInt32(drow[CON_FIELD_ITEMID]);
}
if (drow.Table.Columns.Contains(CON_FIELD_MODIFIEDBY))
{
this.ModifiedBy = Convert.ToInt32(drow[CON_FIELD_MODIFIEDBY]);
}
if (drow.Table.Columns.Contains(CON_FIELD_MODIFIEDDATE))
{
this.ModifiedDate = Convert.ToDateTime(drow[CON_FIELD_MODIFIEDDATE]);
}
if (drow.Table.Columns.Contains(CON_FIELD_PONUMBER))
{
this.PONumber = Convert.ToString(drow[CON_FIELD_PONUMBER]);
}
if (drow.Table.Columns.Contains(CON_FIELD_POUOMID))
{
this.PurchaseUOMID = Convert.ToInt32(drow[CON_FIELD_POUOMID]);
}
if (drow.Table.Columns.Contains(CON_FIELD_POUOM))
{
this.PurchaseUOM = Convert.ToString(drow[CON_FIELD_POUOM]);
}
if (drow.Table.Columns.Contains(CON_FIELD_TAXGROUPCODE))
{
this.TaxGroupCode = Convert.ToString(drow[CON_FIELD_TAXGROUPCODE]);
}
if (drow.Table.Columns.Contains(CON_FIELD_UNITPRICE))
{
this.UnitPrice = Convert.ToDecimal(drow[CON_FIELD_UNITPRICE]);
}
if (drow.Table.Columns.Contains(CON_FIELD_UNITQTY))
{
this.UnitQty = Convert.ToDecimal(drow[CON_FIELD_UNITQTY]);
}
if (drow.Table.Columns.Contains(CON_FIELD_ITEMCODE))
{
this.ItemCode = Convert.ToString(drow[CON_FIELD_ITEMCODE]);
}
if (drow.Table.Columns.Contains(CON_FIELD_PUF))
{
this.PUF = Convert.ToDecimal(drow[CON_FIELD_PUF]);
}
if (drow.Table.Columns.Contains(CON_FIELD_MOQ))
{
this.MOQ = Convert.ToDecimal(drow[CON_FIELD_MOQ]);
}
if (drow.Table.Columns.Contains("IsInclusiveofTax"))
{
this.IsInclusive = Convert.ToBoolean(drow["IsInclusiveofTax"]);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method provides access to the values in each of the columns in a given row.
/// This method makes casts unnecessary when accessing columns.
/// Additionally, Field supports nullable types and maps automatically between DBNull and
/// Nullable when the generic type is nullable.
/// </summary>
/// <param name="row">
/// The input DataRow
/// </param>
/// <param name="column">
/// The input DataColumn specificy which row value to retrieve.
/// </param>
/// <returns>
/// The DataRow value for the column specified.
/// </returns>
public static T Field <T>(this DataRow row, DataColumn column)
{
DataSetUtil.CheckArgumentNull(row, "row");
return(UnboxT <T> .Unbox(row[column]));
}