private void dataGridVIew_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
SkinDataGridView skinDataGridView = (SkinDataGridView)sender;
String json = (String)skinDataGridView.CurrentCell.EditedFormattedValue;
try
{
SampleModel sampleModel = Utils.JsonToObj <SampleModel>(json);
using (var odb = OdbFactory.Open("samplemodel.dat"))
{
List <NSampleModel> list = (List <NSampleModel>)skinDataGridView.DataSource;
var query = odb.Query <NSampleModel>();
query.Descend("id").Constrain(list[skinDataGridView.CurrentRow.Index].id).Equal();
var nSm = query.Execute <NSampleModel>().GetFirst();
nSm.sampleModel = sampleModel;
odb.Store <NSampleModel>(nSm);
}
skinDataGridView.CancelEdit();
loadDataButton.PerformClick();
}
catch (Exception err)
{
MessageBox.Show("错误：修改格式错误。\n详情：" + err.ToString());
}
}
private void UpdateDataGridView(SkinDataGridView skinDataGridView1, List <www_52bang_site_enjoy.MyModel.GroupInfo> groupList, Dictionary <long, int> checkedQQQun)
{
try {
skinDataGridView1.Rows.Clear();
MyDictionaryUtil <long, int> myDictionaryUtil = new MyDictionaryUtil <long, int>();
for (int i = 0; i < groupList.Count; i++)
{
www_52bang_site_enjoy.MyModel.GroupInfo groupInfo = groupList[i];
int result = myDictionaryUtil.GetValue(checkedQQQun, groupInfo.GroupId);
int index = skinDataGridView1.Rows.Add();
if (result == 1)//选中了
{
skinDataGridView1.Rows[index].Cells[0].Value = true;
}
else//未选中
{
skinDataGridView1.Rows[index].Cells[0].Value = false;
}
skinDataGridView1.Rows[index].Cells[1].Value = groupInfo.GroupName;
skinDataGridView1.Rows[index].Cells[2].Value = groupInfo.GroupId;
}
}catch (Exception ex)
{
MyLogUtil.ErrToLog("错误信息：" + ex);
}
}
private void UpdateDataGridView2(SkinDataGridView skinDataGridView1, List <www_52bang_site_enjoy.MyModel.GroupInfo> groupList, Dictionary <long, int> checkedQQQun)
{
MyDictionaryUtil <long, int> myDictionaryUtil = new MyDictionaryUtil <long, int>();
for (int i = 0; i < groupList.Count; i++)
{
www_52bang_site_enjoy.MyModel.GroupInfo groupInfo = groupList[i];
int result = myDictionaryUtil.GetValue(checkedQQQun, groupInfo.GroupId);
int index = skinDataGridView1.Rows.Count - 1;
if (result == 1)//选中了
{
skinDataGridView1.Rows[index].Cells[0].Value = true;
}
else//未选中
{
skinDataGridView1.Rows[index].Cells[0].Value = false;
}
skinDataGridView1.Rows[index].Cells[1].Value = groupInfo.GroupName;
skinDataGridView1.Rows[index].Cells[2].Value = groupInfo.GroupId;
if (!(i == groupList.Count - 1))
{
skinDataGridView1.Rows.Add();
}
}
}
//自定义方法，封装数据显示及存储
private void dgvUpdateData(SkinDataGridView myDgv)
{
int currentID = Convert.ToInt32(myDgv.Rows[myDgv.CurrentCell.RowIndex].Cells["ID"].Value.ToString());
//修改的字段
UserInfo userInfo = new UserInfo()
{
ID = currentID,
modality = myDgv.Rows[myDgv.CurrentCell.RowIndex].Cells["modality"].Value.ToString(),
gender = myDgv.Rows[myDgv.CurrentCell.RowIndex].Cells["gender"].Value.ToString(),
personIDNum = myDgv.Rows[myDgv.CurrentCell.RowIndex].Cells["personIDNum"].Value.ToString(),
phoneNum = myDgv.Rows[myDgv.CurrentCell.RowIndex].Cells["phoneNum"].Value.ToString()
};
//不修改的字段，赋值为之前的记录
var tmp = uInfoRepository.UserInfoes.FirstOrDefault(p => p.ID == currentID);
userInfo.photo = tmp.photo;
userInfo.registrationDeadline = tmp.registrationDeadline;
userInfo.uName = tmp.uName;
userInfo.comment = tmp.comment;
userInfo.age = tmp.age;
if (!userInfo.IsNull())
{
uInfoRepository.SaveUserInfo(userInfo);
MessageBox.Show(string.Format("{0}保存成功了", userInfo.uName));
}
else
{
return;
}
}
//自定义方法——封装下拉选择框 SelectedIndexChanged 事件代码
//实现下拉选择框的选择的值 赋值到 数据视图控件相应的单元格中
private void cboDgvSelectedValue(SkinComboBox myCboDgvContext, SkinDataGridView myDgv)
{
if (myDgv.CurrentCell != null)
{
myDgv.CurrentCell.Value = myCboDgvContext.Items[myCboDgvContext.SelectedIndex];
}
}
/// <summary>
/// 输出data显示
/// </summary>
/// <param name="d"></param>
public void outDataView(Dictionary <string, string> d)
{
SkinDataGridView dataview = skinDataGridView1;
if (d.Count <= 0)
{
dataview.Rows.Clear(); return;
}
dataview.Invoke(new Action(() =>
{
dataview.Rows.Clear();
dataview.Rows.Add(d.Count);
int i = 0;
foreach (var item in d)
{
dataview.Rows[i].Cells[0].Value = item.Key;
dataview.Rows[i].Cells[1].Value = item.Value;
i++;
}
}));
}
/// <summary>
/// 修改时候处理数据
/// </summary>
public Dictionary <string, string> changeDataView()
{
try
{
SkinDataGridView dataview = skinDataGridView1;
dataview.EndEdit();//编辑完成
Dictionary <string, string> newUrlData = new Dictionary <string, string> {
};
int count = dataview.Rows.Count - 1;
for (int i = 0; i < count; i++)
{
newUrlData.Add(dataview.Rows[i].Cells[0].Value.ToString(), dataview.Rows[i].Cells[1].Value.ToString());
}
return(newUrlData);
}
catch (Exception ex)
{
pLogs.logs(ex.ToString());
MessageBox.Show("导入表格错误提示:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
/// <summary>
/// 删除dataview内容
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void skinDataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex != 2)
{
return;
}
SkinDataGridView dataview = skinDataGridView1;
if (dataview.Rows[e.RowIndex].Cells[2].Value != "删除")
{
return;
}
DataGridViewRow rowsData = dataview.Rows[e.RowIndex];
if (rowsData == null)
{
return;
}
string key = dataview.Rows[e.RowIndex].Cells[0].Value.ToString(); //获取key
urlData.Remove(key); //删除list
dataview.Rows.Remove(rowsData);
}
/// <summary>
/// 生成显示
/// </summary>
/// <param name="d"></param>
/// <param name="jar"></param>
/// <param name="key"></param>
private void showDataView(SkinDataGridView d, JArray jar, string[] key)
{
if (jar == null)
{
return;
}
d.Invoke(new Action(() =>
{
d.Rows.Clear();
if (key.Length < 0)
{
d.DataSource = jar; return;
}
foreach (JObject item in jar)
{
string[] temp = new string[key.Length];
for (int i = 0; i < key.Length; i++)
{
temp[i] = item.GetValue(key[i]).ToString();
}
d.Rows.Add(temp);
}
}));
}
public ControlDataGridView(SkinDataGridView skinDataGridView)
{
this.skinDataGridView = skinDataGridView;
}
/// <summary>
/// 加载数据到列表
/// </summary>
/// <param name="dataGridView"></param>
public void InitData(SkinDataGridView dataGridView, Action getPage, int index = 1, int size = 13)
{
pageIndex = (index - 1) * size;
var pageSeze = pageIndex + size;
if (pageSeze > items.Count)
{
pageSeze = pageIndex + (items.Count - pageIndex);
}
dataGridView.Rows.Clear();
//正常的文本
void AddRIGHT(TblModel x)
{
dataGridView.Rows.Add(
Resource.PROCESS_RIGHT,
x.Key,
x.Value,
x.Transform
);
}
void AddWRONG(TblModel x)
{
dataGridView.Rows.Add(
Resource.PROCESS_WRONG,
x.Key,
x.Value,
x.Transform
);
}
var task = new Task(() =>
{
for (var i = pageIndex; i < pageSeze; i++)
{
var x = items[i];
if (x.Transform.Length <= 0)
{
mainForm.Invoke((Action <TblModel>)AddRIGHT, x);
}
else
{
//原文的长度
var valueLength = EncodingHelp.GetStringLength(x.Value);
//翻译的长度
var transLength = EncodingHelp.GetStringLength(x.Transform);
if (transLength > valueLength)
{
mainForm.Invoke((Action <TblModel>)AddWRONG, x);
}
else
{
mainForm.Invoke((Action <TblModel>)AddRIGHT, x);
}
}
}
if (getPage != null)
{
mainForm.Invoke(getPage);
}
});
task.Start();
}
public void skinDataGridView_RemoveAt(SkinDataGridView skinDataGridView)//获取数据库数据--删除行
{
skinDataGridView.Rows.RemoveAt(skinDataGridView.CurrentCell.RowIndex);
this.sqlCommandBuilder = new SqlCommandBuilder(this.sqlDataAdapter);
this.sqlDataAdapter.Update(this.dataTable);
}
public void skinDataGridView_modification(SkinDataGridView skinDataGridView) //获取数据库数据--修改表
{
this.dataTable = new DataTable(); //实例化缓存对象
this.sqlCommandBuilder = new SqlCommandBuilder(this.sqlDataAdapter);
this.sqlDataAdapter.Update((DataTable)skinDataGridView.DataSource);
}
public void skinDataGridView_update(SkinDataGridView skinDataGridView) //获取数据库数据--更新表
{
this.dataTable = new DataTable(); //实例化缓存对象
this.sqlDataAdapter.Fill(this.dataTable); //获取表
skinDataGridView.DataSource = this.dataTable; //绑定数据源
}
