public void AddNew()
{
//create the source datatable
DataTable dt = DataProvider.CreateChildDataTable();
//create the dataview for the table
DataView dv = new DataView(dt);
int CountView = dv.Count;
int CountTable = dt.Rows.Count;
DataRowView drv = null;
// AddNew - DataView Row Count
drv = dv.AddNew();
Assert.Equal(dv.Count, CountView + 1);
// AddNew - Table Row Count
Assert.Equal(dt.Rows.Count, CountTable);
// AddNew - new row in DataTable
drv.EndEdit();
Assert.Equal(dt.Rows.Count, CountTable + 1);
// AddNew - new row != null
Assert.Equal(true, drv != null);
// AddNew - check table
Assert.Equal(dt, drv.Row.Table);
}
/// <summary>
/// Refreshes a UserDefault in the local Cache that has been updated on the
/// Server side or in the DB.
///
/// @comment This is needed for the case where several PetraClient instances of
/// the same Petra User are running and they are updating the same UserDefault.
/// On detecting such a 'collision', the PetraServer queues a ClientTask to
/// refresh the specific UserDefault in the local Cache, and the
/// TClientTaskInstance.Execute background thread then invokes this function.
///
/// </summary>
/// <param name="AChangedUserDefaultCode">UserDefault Code to update</param>
/// <param name="AChangedUserDefaultValue">Changed UserDefault Value</param>
/// <param name="AChangedUserDefaultModId">ModificationID of the changed UserDefault
/// DataRow
/// </param>
/// <returns>void</returns>
public static void RefreshCachedUserDefault(String AChangedUserDefaultCode, String AChangedUserDefaultValue, String AChangedUserDefaultModId)
{
// TLogging.Log('Refreshing DefaultCode ''' + AChangedUserDefaultCode + ''' with Value: ''' + AChangedUserDefaultValue + '''');
// Split String into String Array
String[] ChangedUserDefaultCodes = AChangedUserDefaultCode.Split(new Char[] { RemotingConstants.GCLIENTTASKPARAMETER_SEPARATOR[0] });
String[] ChangedUserDefaultValues = AChangedUserDefaultValue.Split(new Char[] { RemotingConstants.GCLIENTTASKPARAMETER_SEPARATOR[0] });
String[] ChangedUserDefaultModIds = AChangedUserDefaultModId.Split(new Char[] { RemotingConstants.GCLIENTTASKPARAMETER_SEPARATOR[0] });
for (Int16 Counter = 0; Counter <= ChangedUserDefaultCodes.Length - 1; Counter += 1)
{
// TLogging.Log('Refreshing UserDefault ''' + ChangedUserDefaultCodes[Counter] + ''' with value ''' + ChangedUserDefaultValues[Counter] + ''' (ModificationID: ''' + ChangedUserDefaultModIds[Counter] + '''');
Int32 FoundInRow = UUserDefaults.Find(ChangedUserDefaultCodes[Counter]);
if (FoundInRow != -1)
{
// User default found
// TLogging.Log('Existing UserDefault ''' +
// UUserDefaults.Item[FoundInRow].Item[SUserDefaultsTable.GetDefaultCodeDBName].ToString + ''' with value ''' +
// UUserDefaults.Item[FoundInRow].Item[SUserDefaultsTable.GetDefaultValueDBName].ToString + ''' (ModificationID: ''' +
// UUserDefaults.Item[FoundInRow].Item[SUserDefaultsTable.GetModificationIDDBName].ToString + '''');
if (ChangedUserDefaultValues[Counter] != UUserDefaults[FoundInRow][SUserDefaultsTable.GetDefaultValueDBName()].ToString())
{
// Update only if the value is actually different
UUserDefaults[FoundInRow][SUserDefaultsTable.GetDefaultValueDBName()] = ChangedUserDefaultValues[Counter];
}
UUserDefaults[FoundInRow][SUserDefaultsTable.GetModificationIdDBName()] = Convert.ToDateTime(ChangedUserDefaultModIds[Counter]);
// Mark this refreshed UserDefault as unchanged
UUserDefaults[FoundInRow].Row.AcceptChanges();
}
else
{
// User default not found, add it to the user defaults table
// TLogging.Log('UserDefault doesn''t exist yet > creating new one');
DataRowView Tmp = UUserDefaults.AddNew();
Tmp[SUserDefaultsTable.GetUserIdDBName()] = Ict.Petra.Shared.UserInfo.GUserInfo.UserID;
Tmp[SUserDefaultsTable.GetDefaultCodeDBName()] = ChangedUserDefaultCodes[Counter];
Tmp[SUserDefaultsTable.GetDefaultValueDBName()] = ChangedUserDefaultValues[Counter];
Tmp[SUserDefaultsTable.GetModificationIdDBName()] = ChangedUserDefaultModIds[Counter];
Tmp.EndEdit();
// Mark this refreshed UserDefault as unchanged
Tmp.Row.AcceptChanges();
// TLogging.Log('UserDefault: new Row added, RowState: ' + Enum(Tmp.Row.RowState).ToString("G"));
}
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
if (!Common.Validate.IsDateTime(tboxTimeB.Text) || !Common.Validate.IsDateTime(tboxTimeE.Text))
{
Common.MsgBox.Show(this, App_GlobalResources.Language.Tip_TimeError);
return;
}
string sqlWhere = "";
DateTime searchdateB = DateTime.Now;
DateTime searchdateE = DateTime.Now;
if (tboxTimeB.Text.Length > 0)
{
searchdateB = Convert.ToDateTime(tboxTimeB.Text);
}
if (tboxTimeE.Text.Length > 0)
{
searchdateE = Convert.ToDateTime(tboxTimeE.Text);
}
if (!string.IsNullOrEmpty(ddlChannel.SelectedValue.Trim()))
{
sqlWhere += string.Format(" AND F_ChannelID=N'{0}'", ddlChannel.SelectedValue);
}
string sql = string.Format("SELECT LEFT(CONVERT(VARCHAR(100),F_InsertTime,120), 13) Time,COUNT(F_UserID) RechargeNum,COUNT(DISTINCT F_UserID) RechargeNumOfPeople,SUM(F_Price) RechargeAmount FROM T_Deposit_Verify_Result_Log WHERE F_DepositResult=1 AND CONVERT(VARCHAR(100),F_InsertTime,23)>='{0}' AND CONVERT(VARCHAR(100),F_InsertTime,23)<='{1}' {2} GROUP BY LEFT(CONVERT(VARCHAR(100),F_InsertTime,120), 13) ", searchdateB.ToString("yyyy-MM-dd"), searchdateE.ToString("yyyy-MM-dd"), sqlWhere);
try
{
ds = DBHelperUserCoreDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
if (myView.Count == 0)
{
lblerro.Visible = true;
myView.AddNew();
}
else
{
lblerro.Visible = false;
}
GridView1.DataSource = myView;
GridView1.DataBind();
}
catch (System.Exception ex)
{
GridView1.DataSource = null;
GridView1.DataBind();
lblerro.Visible = true;
lblerro.Text = App_GlobalResources.Language.LblError + ex.Message;
}
}
private void RegisterBindingSourceOnAddingNew(object sender, AddingNewEventArgs e)
{
if (_registerBindingSource.List.Count >= 1)
{
return;
}
DataView view = _registerBindingSource.List as DataView;
DataRowView row = view.AddNew();
row["LandID"] = 1;
row["CustomerID"] = ((DataRowView)_customerBindingSource.Current)[0];
e.NewObject = (object)row;
_registerBindingSource.MoveLast();
}
static public void AddNew(ModelBase model, DataView v, int remarkTypeId, string remarks = null, string title = null, bool alert = false)
{
DataRowView r = v.AddNew();
r["TableId"] = (model is SponsorModel) ? 9 : 10;
r["FKRowGUID"] = model.GUID;
r["RemarkTypeId"] = remarkTypeId;
r["Remarks"] = remarks;
r["Title"] = title;
r["Alert"] = alert;
r["CreateDate"] = r["LastUpdate"] = DateTime.Now;
r["CreateAgentGUID"] = UserModel.Current.GUID;
r["CreateTaxOfficeId"] = SettingsModel.TaxOfficeId;
r.Row.Table.Rows.Add(r.Row);
}
/// <summary>
/// Setup new DataRow with some values
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void _bindingSource_AddingNew(object sender, AddingNewEventArgs e)
{
DataView dataView = _bindingSource.List as DataView;
// ReSharper disable once PossibleNullReferenceException
DataRowView dataRowView = dataView.AddNew();
dataRowView["PartName"] = "Just added";
dataRowView["Quantity"] = 10;
dataRowView["Cost"] = 1.6M;
e.NewObject = dataRowView;
_bindingSource.MoveLast();
}
[Test] public void AllowNew()
{
DataTable dt = DataProvider.CreateParentDataTable();
DataView dv = new DataView(dt);
// AllowNew - default value
Assert.AreEqual(true, dv.AllowNew, "DV18");
// AllowNew - true
dv.AllowNew = true;
Assert.AreEqual(true, dv.AllowNew, "DV19");
// AllowNew - false
dv.AllowNew = false;
Assert.AreEqual(false, dv.AllowNew, "DV20");
// AllowNew - exception
try
{
dv.AddNew();
Assert.Fail("DV21: AddNew Failed to throw DataException");
}
catch (DataException) {}
catch (AssertionException exc) { throw exc; }
catch (Exception exc)
{
Assert.Fail("DV22: AddNew. Wrong exception type. Got:" + exc);
}
dv.AllowNew = true;
int RowsCount = dv.Count;
// AllowNew - exception
dv.AddNew();
Assert.AreEqual(RowsCount + 1, dv.Count, "DV23");
}
public void _bs1_AddingNew(object sender, AddingNewEventArgs e)
{
BindingSource bs = (BindingSource)sender;
DataView view = (DataView)bs.List;
DataRowView newRow = view.AddNew();
newRow["SerialNumber"] = textBox_SerialNumber.Text;
newRow["Price"] = textBox_Price.Text;
newRow["Builder"] = textBox_Builder.Text;
newRow["Model"] = textBox_Model.Text;
newRow["Type"] = textBox_Type.Text;
newRow["BackWood"] = textBox_BackWood.Text;
newRow["TopWood"] = textBox_TopWood.Text;
e.NewObject = newRow;
}
protected void BindFields()
{
DataSet data = new Survey().GetAllAdGroupDetails(((PageBase)Page).SurveyId);
DataView dv1 = data.DefaultViewManager.CreateDataView(data.Tables[0]);
// when no results found we add new empty row and clear it cells
if (dv1.Count == 0)
{
dv1.AddNew();
}
lvADGroups.DataSource = dv1;
lvADGroups.DataBind();
}
private void cardView1_KeyDown(object sender, KeyEventArgs e)
{
CardView Cards = sender as CardView;
if (e.KeyCode == Keys.Insert && !Cards.IsEditing)
{
DataView Data = Cards.DataSource as DataView;
if (Data != null)
{
Data.AddNew();
Cards.FocusedColumn = Cards.GetVisibleColumn(0);
Cards.ShowEditor();
e.Handled = true;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataRowView row = _servicemans.AddNew();
row.BeginEdit();
Form form = new EditServiceman(row);
form.ShowDialog();
row.EndEdit();
}
catch (Exception ex)
{
HandleException(ex.Message);
}
}
private void AddressBindingSourceOnAddingNew(object sender, AddingNewEventArgs addingNewEventArgs)
{
if (_addressBindingSource.List.Count >= 1)
{
return;
}
DataView view = _addressBindingSource.List as DataView;
DataRowView row = view.AddNew();
row["City"] = "Славянск";
row["AdminDivisionID"] = 5;
row["CustomerID"] = ((DataRowView)_customerBindingSource.Current)[0];
addingNewEventArgs.NewObject = (object)row;
_addressBindingSource.MoveLast();
}
public static Permission newPermission(SQLiteConnection connection, DataView rowView, User user)
{
DataRowView row = rowView.AddNew();
Permission permission = new Permission(row, connection, user);
permission.Id = Guid.NewGuid().ToString();
permission.Name = "New Permission";
permission.Description = "";
permission.CanRead = false;
permission.CanWrite = false;
permission.CanCreate = false;
permission.CanDelete = false;
permission.Special = false;
return(permission);
}
public static User NewUser(SQLiteConnection connection, DataView rowView, User user)
{
DataRowView row = rowView.AddNew();
User nuser = new User(row, connection);
nuser.Id = Guid.NewGuid().ToString();
nuser.ProfilePic = Utils.ImageToByte(Resources.UserIcon);
nuser.DateCreated = DateTime.Now;
nuser.State = EntityStates.Enabled;
nuser.LogInDate = DateTime.Now;
nuser.DateCreated = DateTime.Now;
nuser.DateModified = DateTime.Now;
nuser.State = EntityStates.Enabled;
return(nuser);
}
private void bindingSource1_AddingNew(object sender, AddingNewEventArgs e)
{
int columnindex = 0;
int colindex = 0;
DataView view = this.bindingSource1.List as DataView;
DataRowView rowview = view.AddNew();
rowview["Key"] = "button" + view.Count.ToString();
rowview["MessageCode"] = "0";
rowview["DesigeCaption"] = "显示标题";
rowview["DllName"] = string.Empty;
e.NewObject = rowview;
KzxDropDownButtonItem xmlrow = KzxDropDownButtonItem.Converter(rowview);
this.propertyGrid1.SelectedObject = xmlrow;
}
/// <summary>
/// 为当前项目添加子项目
/// </summary>
public void AddChd()
{
DataRowView drv = this.bindingSource1.Current as DataRowView;
if (drv != null)
{
DataView dv = this.bindingSource1.List as DataView;
DataRowView row = dv.AddNew();
row.BeginEdit();
row["Number"] = GetChdName();
row["ParentID"] = drv["ID"];
row["UnID"] = this.Activitie.ID;
row["Coefficient"] = 100;
row.EndEdit();
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void bind()
{
string sql = "";
sql = @"SELECT top 30 * FROM T_BaseGameName where 1=1 ";
if (Common.Validate.IsInt(tboxExcelID.Text))
{
sql += " and F_ExcelID=" + tboxExcelID.Text + "";
}
if (tboxTaskName.Text.Length > 0)
{
sql += " and F_Name like '%" + tboxTaskName.Text + "%' ";
}
if ((tboxTaskName.Text + tboxTaskName.Text).Trim().Length == 0)
{
sql += " and 1<>1 ";
}
try
{
ds = DBHelperDigGameDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
if (myView.Count == 0)
{
lblerro.Visible = true;
myView.AddNew();
}
else
{
lblerro.Visible = false;
}
GridView1.DataSource = myView;
GridView1.DataBind();
}
catch (System.Exception ex)
{
GridView1.DataSource = null;
GridView1.DataBind();
lblerro.Visible = true;
lblerro.Text = App_GlobalResources.Language.LblError + ex.Message;
}
}
public void AddNewDataRowView(DataView dataView)
{
DataRowView rowView = dataView.AddNew();
// Change values in the DataRow.
ForAddRow additionalform = new ForAddRow();
rowView["Name"] = additionalform.txbName.Text;
rowView["Surname"] = additionalform.txbSurName.Text;
rowView["City"] = additionalform.txbCity.Text;
rowView["PhoneNumber"] = additionalform.txbPhone.Text;
rowView["BirhDate"] = additionalform.txbBirth.Text;
rowView.EndEdit();
MyNotebook form = new MyNotebook();
form.dgv1.DataSource = rowView;
}
/// <summary>МЕТОД Добавление Назначений ЛС</summary>
private void MET_AddNaznLS()
{
// Добавляем данные в sqlDs
PRI_Row = PRI_DaViNazn.AddNew();
PRI_Row["Cod"] = -1;
PRI_Row["DateN"] = PROP_DateK > DateTime.Today ? DateTime.Today : Convert.ToDateTime(MyGlo.HashAPSTAC["DN"]);
PRI_Row["Kurs"] = 1;
PRI_Row["Period"] = 1;
PRI_Row["Amt"] = 1;
PRI_Row["NameLS"] = "Текст назначения";
PRI_Row["UserVrach"] = MyGlo.User;
PRI_Row["DateK"] = MET_PoleDat("DateN").AddDays((MET_PoleDou("Kurs") - 1) * MET_PoleInt("Period"));
PRI_Row["DelDate"] = PRI_Row["DateK"];
PRI_Row.EndEdit();
eleDataGrid.SelectedItem = PRI_Row;
eleDataGrid.RowDetailsVisibilityMode = DataGridRowDetailsVisibilityMode.VisibleWhenSelected;
}
public static FamilyTemplate NewTemplate(SQLiteConnection connection, DataView rowView, User user, object application)
{
DataRowView row = rowView.AddNew();
FamilyTemplate template = new FamilyTemplate(row, connection, user, application);
template.Id = Guid.NewGuid().ToString();
template.Version = new Version(0, 0, 0);
template.DateCreated = DateTime.Now;
template.DateModified = DateTime.Now;
template.CreatedById = user.Id;
template.CreatedBy = user;
template.ModifiedById = user.Id;
template.ModifiedBy = user;
return(template);
}
private void AddLine(object sender, EventArgs e)
{
#region 增加子件
IRefDAL dal = new InventoryDAL(Information.UserInfo.ConnU8);
RefForm frm = new RefForm(dal);
if (frm.ShowDialog() == DialogResult.OK)
{
var r = dvDetail.AddNew();
r.BeginEdit();
r["guid"] = woGuid;
r["DInvCode"] = frm.rows[0]["cInvCode"];
r["DInvName"] = frm.rows[0]["cInvName"];
r["DInvStd"] = frm.rows[0]["cInvStd"];
r.EndEdit();
}
#endregion
}
private void button1_Click(object sender, EventArgs e)
{
cTypeOrderPole ctop = new cTypeOrderPole();
FormEditPoleName F = new FormEditPoleName(ctop, "Добавить");
if (F.ShowDialog(this) == DialogResult.OK)
{
DataRowView drvchild = TypeOrderPoleView.AddNew();
ctop.ThisToRow(drvchild.Row);
drvchild.EndEdit();
ReNumberChild();
listView1.VirtualListSize = TypeOrderPoleView.Count;
listView1.Refresh();
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
if (!Common.Validate.IsDateTime(tboxTimeB.Text))
{
Common.MsgBox.Show(this, App_GlobalResources.Language.Tip_TimeError);
return;
}
string sqlWhere = "";
DateTime searchdateB = DateTime.Now;
DateTime searchdateE = DateTime.Now;
if (tboxTimeB.Text.Length > 0)
{
searchdateB = Convert.ToDateTime(tboxTimeB.Text);
}
if (!string.IsNullOrEmpty(ddlChannel.SelectedValue.Trim()))
{
sqlWhere += string.Format(" AND F_ChannelID=N'{0}'", ddlChannel.SelectedValue);
}
string sql = string.Format("SELECT LEFT(CONVERT(VARCHAR(100),F_LoginTime,120), 13) DateTime,COUNT(F_UserID) LoginNum,COUNT(DISTINCT F_UserID) PlayerNum FROM T_UserEnterExitLog{0} GROUP BY LEFT(CONVERT(VARCHAR(100),F_LoginTime,120), 13) ORDER BY LEFT(CONVERT(VARCHAR(100),F_LoginTime,120), 13)", searchdateB.ToString("yyyyMMdd"));
try
{
ds = DBHelperGameLogDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
if (myView.Count == 0)
{
lblerro.Visible = true;
myView.AddNew();
}
else
{
lblerro.Visible = false;
}
GridView1.DataSource = myView;
GridView1.DataBind();
}
catch (System.Exception ex)
{
GridView1.DataSource = null;
GridView1.DataBind();
lblerro.Visible = true;
lblerro.Text = App_GlobalResources.Language.LblError + ex.Message;
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
if (!Common.Validate.IsDateTime(tboxTimeB.Text) || !Common.Validate.IsDateTime(tboxTimeE.Text))
{
Common.MsgBox.Show(this, App_GlobalResources.Language.Tip_TimeError);
return;
}
DateTime searchdateB = DateTime.Now.AddDays(-6);
DateTime searchdateE = DateTime.Now;
if (tboxTimeB.Text.Length > 0)
{
searchdateB = Convert.ToDateTime(tboxTimeB.Text);
}
if (tboxTimeE.Text.Length > 0)
{
searchdateE = Convert.ToDateTime(tboxTimeE.Text);
}
string sql = string.Format("SELECT COUNT (F_UserID) RechargeNumOfPeople,SUM (CASE WHEN Num = 2 THEN 1 ELSE 0 END) RechargeNumOfPeople_2,SUM (CASE WHEN Num = 3 THEN 1 ELSE 0 END) RechargeNumOfPeople_3,CAST (CONVERT (DECIMAL (18, 2),SUM (CASE WHEN Num = 2 THEN 1 ELSE 0 END) / CAST (ISNULL(NULLIF(COUNT (F_UserID), 0), 1) AS FLOAT) * 100) AS VARCHAR (10)) + '%' AS RechargeNumOfPeople_2Lv,CAST (CONVERT (DECIMAL (18, 2),SUM (CASE WHEN Num = 3 THEN 1 ELSE 0 END) / CAST (ISNULL(NULLIF(COUNT (F_UserID), 0), 1) AS FLOAT) * 100) AS VARCHAR (10)) + '%' AS RechargeNumOfPeople_3Lv FROM (SELECT F_UserID,COUNT (F_UserID) Num FROM UserCoreDB.dbo.T_Deposit_Verify_Result_Log WHERE F_DepositResult = 1 AND CONVERT (VARCHAR (100),F_InsertTime,23) >= '{0}' AND CONVERT (VARCHAR (100),F_InsertTime,23) <= '{1}' GROUP BY F_UserID) TEMP", searchdateB.ToString("yyyy-MM-dd"), searchdateE.ToString("yyyy-MM-dd"));
try
{
ds = DBHelperUserCoreDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
if (myView.Count == 0)
{
lblerro.Visible = true;
myView.AddNew();
}
else
{
lblerro.Visible = false;
}
GridView1.DataSource = myView;
GridView1.DataBind();
}
catch (System.Exception ex)
{
GridView1.DataSource = null;
GridView1.DataBind();
lblerro.Visible = true;
lblerro.Text = App_GlobalResources.Language.LblError + ex.Message;
}
}
public static FamilyComponent NewFamilyComponent(SQLiteConnection connection, DataView rowView, User user, object application, FamilyComponentType type)
{
DataRowView row = rowView.AddNew();
FamilyComponent component = new FamilyComponent(row, connection, user, application);
component.Id = Guid.NewGuid().ToString();
component.Thumbnail = new byte[byte.MaxValue];
component.Version = new Version(0, 0, 0);
component.DateCreated = DateTime.Now;
component.DateModified = DateTime.Now;
component.CreatedById = user.Id;
component.ModifiedById = user.Id;
component.CreatedBy = user;
component.ModifiedBy = user;
component.FamilyComponentTypeId = type.Id;
return(component);
}
/// <summary>
/// Handles the Click event of the Insert button
/// </summary>
/// <param name="sender">Object that fired the event</param>
/// <param name="e">.NET supplied event parameters</param>
private void btnInsert_Click(object sender, EventArgs e)
{
DataView view = ((DataView)dgList.DataSource);
DataRowView row = view.AddNew();
row.EndEdit();
for (int i = view.Count - 1; i > dgList.CurrentCell.RowNumber; i--)
{
row = view[i];
row.BeginEdit();
row.Row[0] = view[i - 1][0].ToString();
row.EndEdit();
}
row = view[dgList.CurrentCell.RowNumber];
row.BeginEdit();
row[0] = string.Empty;
row.EndEdit();
}
public static void UpdateSettingValue(string key, string value, string memo)
{
DataView setView = (DataView)HttpContext.Current.Cache["Setting"];
setView.RowFilter = string.Format("KEY='{0}'", key ?? "");
if (setView.Count == 0)
{
DataRowView newViewRow = setView.AddNew();
newViewRow["KEY"] = key;
newViewRow["VALUE"] = value;
newViewRow["MEMO"] = memo;
}
else
{
setView[0]["VALUE"] = value;
setView[0]["MEMO"] = memo;
}
}
private void SelectDataRow()
{
if (FeatureMaster.SelectedRowFeat != null)
{
FeatureMaster.Feature = FeatureMaster.SelectedRowFeat["FEATURE_DESC"].ToString();
FeatureMaster.FeatureCode = FeatureMaster.SelectedRowFeat["FEATURE_CODE"].ToString();
FeatureMaster.CharacteristicsMasterDetails = _featureMasterbll.GetCharactersiticsMasterGrid(FeatureMaster.OperationCode, FeatureMaster.FeatureCode);
if (FeatureMaster.CharacteristicsMasterDetails.IsNotNullOrEmpty() && EditButtonIsEnable == false)
{
DataView charactMast = FeatureMaster.CharacteristicsMasterDetails;
DataRowView newRow = charactMast.AddNew();
newRow.BeginEdit();
newRow["SNO"] = FeatureMaster.CharacteristicsMasterDetails.Count;
newRow.EndEdit();
FeatureMaster.CharacteristicsMasterDetails = charactMast;
}
}
}
protected void BindLookupCodesGrid()
{
string selectedFieldName = fieldName.SelectedValue;
if (!string.IsNullOrEmpty(selectedFieldName))
{
LookupCodeDa lkpDa = new LookupCodeDa();
DataSet lkpDs = lkpDa.GetLookupsByFieldName(selectedFieldName);
DataView view = lkpDs.Tables[0].DefaultView;
// Add empty rows
for (int i = 0; i < BLANK_LOOKUPCODE_ROWS; i++)
{
view.AddNew();
}
LookupCodeGrid.DataSource = view;
LookupCodeGrid.DataBind();
}
}
public void IsEdit()
{
DataTable dt = new DataTable("table");
dt.Columns.Add("col");
dt.Rows.Add((new object [] { "val" }));
DataView dv = new DataView(dt);
DataRowView drv = dv [0];
dt.Rows [0].BeginEdit();
AssertEquals("DataView.Item", true, drv.IsEdit);
drv = dv.AddNew();
drv.Row ["col"] = "test";
drv.Row.CancelEdit();
AssertEquals("AddNew", false, drv.IsEdit);
}
/// <summary>
/// 绑定注册玩家数
/// </summary>
public void BindRegisterPlayerNum()
{
if (!Common.Validate.IsDateTime(tboxTimeB.Text) || !Common.Validate.IsDateTime(tboxTimeE.Text))
{
Common.MsgBox.Show(this, App_GlobalResources.Language.Tip_TimeError);
return;
}
string sqlWhere = "";
DateTime searchdateB = DateTime.Now.AddDays(-7);
DateTime searchdateE = DateTime.Now;
if (tboxTimeB.Text.Length > 0)
{
searchdateB = Convert.ToDateTime(tboxTimeB.Text);
}
if (tboxTimeE.Text.Length > 0)
{
searchdateE = Convert.ToDateTime(tboxTimeE.Text);
}
if (!string.IsNullOrEmpty(ddlChannel.SelectedValue.Trim()))
{
sqlWhere += string.Format(" AND F_ChannelID=N'{0}'", ddlChannel.SelectedValue);
}
string sql = string.Format("SELECT CONVERT(VARCHAR(100),F_CreatTime,23) DateTime,COUNT(F_UserID) Num FROM T_User WHERE CONVERT(VARCHAR(100),F_CreatTime,23)>='{0}' AND CONVERT(VARCHAR(100),F_CreatTime,23)<='{1}' GROUP BY CONVERT(VARCHAR(100),F_CreatTime,23)", searchdateB.ToString("yyyy-MM-dd"), searchdateE.ToString("yyyy-MM-dd"), sqlWhere);
try
{
ds = DBHelperUserCoreDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
if (myView.Count == 0)
{
myView.AddNew();
}
gvRegister.DataSource = myView;
gvRegister.DataBind();
}
catch (System.Exception ex)
{
gvRegister.DataSource = null;
gvRegister.DataBind();
}
}
public void IsNew()
{
DataTable dt = DataProvider.CreateParentDataTable();
DataView dv = new DataView(dt);
DataRowView drv = dv[0];
// existing row
Assert.Equal(false, drv.IsNew);
// add new row
drv = dv.AddNew();
Assert.Equal(true, drv.IsNew);
}
public void Bug18898()
{
var table = new DataTable();
table.Columns.Add("col1");
table.Columns.Add("col2");
table.Rows.Add("1", "2");
table.Rows.Add("4", "3");
table.AcceptChanges();
table.Rows.Add("5", "6");
DataView dv = new DataView(table, string.Empty, string.Empty, DataViewRowState.Added);
dv.AllowNew = true;
var new_row = dv.AddNew();
new_row[0] = "7";
new_row[1] = "8";
var another_new_row = dv.AddNew();
another_new_row[0] = "9";
another_new_row[1] = "10";
Assert.Equal(dv[2][0], "9");
//This should not throw a System.Data.VersionNotFoundException: "There is no Proposed data to accces"
Assert.Equal(dv[1][0], "7");
}
public void CancelEditAndEvents()
{
string reference = " =====ItemAdded:3 ------4 =====ItemAdded:3 =====ItemAdded:4 ------5 =====ItemAdded:4 =====ItemAdded:5 ------6 =====ItemDeleted:5 ------5 =====ItemAdded:5";
_eventWriter = new StringWriter();
DataTable dt = new DataTable();
dt.Columns.Add("col1");
dt.Columns.Add("col2");
dt.Columns.Add("col3");
dt.Rows.Add(new object[] { 1, 2, 3 });
dt.Rows.Add(new object[] { 1, 2, 3 });
dt.Rows.Add(new object[] { 1, 2, 3 });
DataView dv = new DataView(dt);
dv.ListChanged += new ListChangedEventHandler(ListChanged);
DataRowView a1 = dv.AddNew();
_eventWriter.Write(" ------" + dv.Count);
// I wonder why but MS fires another event here.
a1 = dv.AddNew();
_eventWriter.Write(" ------" + dv.Count);
// I wonder why but MS fires another event here.
DataRowView a2 = dv.AddNew();
_eventWriter.Write(" ------" + dv.Count);
a2.CancelEdit();
_eventWriter.Write(" ------" + dv.Count);
DataRowView a3 = dv.AddNew();
Assert.Equal(reference, _eventWriter.ToString());
}
public void AllowNew()
{
DataTable dt = DataProvider.CreateParentDataTable();
DataView dv = new DataView(dt);
// AllowNew - default value
Assert.Equal(true, dv.AllowNew);
// AllowNew - true
dv.AllowNew = true;
Assert.Equal(true, dv.AllowNew);
// AllowNew - false
dv.AllowNew = false;
Assert.Equal(false, dv.AllowNew);
// AllowNew - exception
Assert.Throws<DataException>(() =>
{
dv.AddNew();
});
dv.AllowNew = true;
int RowsCount = dv.Count;
// AllowNew - exception
dv.AddNew();
Assert.Equal(RowsCount + 1, dv.Count);
}
public void ListChanged()
{
DataTable dt = DataProvider.CreateParentDataTable();
DataView dv = new DataView(dt);
//add event handler
dv.ListChanged += new ListChangedEventHandler(dv_ListChanged);
// ----- Change Value ---------
_evProp = null;
// change value - Event raised
dv[1]["String1"] = "something";
Assert.Equal(true, _evProp != null);
// change value - ListChangedType
Assert.Equal(ListChangedType.ItemChanged, _evProp.lstType);
// change value - NewIndex
Assert.Equal(1, _evProp.NewIndex);
// change value - OldIndex
Assert.Equal(1, _evProp.OldIndex);
// ----- Add New ---------
_evProp = null;
// Add New - Event raised
dv.AddNew();
Assert.Equal(true, _evProp != null);
// Add New - ListChangedType
Assert.Equal(ListChangedType.ItemAdded, _evProp.lstType);
// Add New - NewIndex
Assert.Equal(6, _evProp.NewIndex);
// Add New - OldIndex
Assert.Equal(-1, _evProp.OldIndex);
// ----- Sort ---------
_evProp = null;
// sort - Event raised
dv.Sort = "ParentId Desc";
Assert.Equal(true, _evProp != null);
// sort - ListChangedType
Assert.Equal(ListChangedType.Reset, _evProp.lstType);
// sort - NewIndex
Assert.Equal(-1, _evProp.NewIndex);
// sort - OldIndex
Assert.Equal(-1, _evProp.OldIndex);
//ListChangedType - this was not checked
//Move
//PropertyDescriptorAdded - A PropertyDescriptor was added, which changed the schema.
//PropertyDescriptorChanged - A PropertyDescriptor was changed, which changed the schema.
//PropertyDescriptorDeleted
}
public void IsEdit()
{
DataTable dt = new DataTable("table");
dt.Columns.Add("col");
dt.Rows.Add((new object[] { "val" }));
DataView dv = new DataView(dt);
DataRowView drv = dv[0];
dt.Rows[0].BeginEdit();
Assert.Equal(true, drv.IsEdit);
drv = dv.AddNew();
drv.Row["col"] = "test";
drv.Row.CancelEdit();
Assert.Equal(false, drv.IsEdit);
}
public void ItemException()
{
Assert.Throws<RowNotInTableException>(() =>
{
DataTable dt = new DataTable("table");
dt.Columns.Add("col");
dt.Rows.Add((new object[] { "val" }));
DataView dv = new DataView(dt);
DataRowView drv = dv.AddNew();
drv.Row["col"] = "test";
drv.Row.CancelEdit();
object o = drv["col"];
});
}
public void RowVersion1()
{
// I guess we could write better tests.
DataTable dt = new DataTable("table");
dt.Columns.Add("col");
dt.Rows.Add(new object[] { 1 });
DataView dv = new DataView(dt);
DataRowView drv = dv.AddNew();
Assert.Equal(DataRowVersion.Current, drv.RowVersion);
Assert.Equal(DataRowVersion.Current, dv[0].RowVersion);
drv["col"] = "mod";
Assert.Equal(DataRowVersion.Current, drv.RowVersion);
Assert.Equal(DataRowVersion.Current, dv[0].RowVersion);
dt.AcceptChanges();
Assert.Equal(DataRowVersion.Current, drv.RowVersion);
Assert.Equal(DataRowVersion.Current, dv[0].RowVersion);
drv.EndEdit();
dv[0].EndEdit();
Assert.Equal(DataRowVersion.Current, drv.RowVersion);
Assert.Equal(DataRowVersion.Current, dv[0].RowVersion);
}
