public int Update(DataTable table) { if (_tablename != "") { string keyname = "";//Helper string condition = ""; int rowcount = table.Rows.Count; char[] charSeparators = new char[] { ',' }; DBAccess.DBHelper h = new DBAccess.DBHelper(); keyname = h.GetKeyField(_tablename); SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename); string[] keylist = keyname.Split(charSeparators, System.StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < rowcount; i++) { condition = "(1=1)"; for (int j = 0; j < keylist.Length; j++) { condition = condition + " and " + keylist[j] + "='" + table.Rows[i][keylist[j]].ToString() + "' "; } adapter.SelectCommand.CommandText = "select * from " + _tablename + " where " + condition; DataSet desDS = new DataSet(_tablename); adapter.Fill(desDS); if (desDS.Tables[0].Rows.Count > 0)//������������ { for (int descount = 0; descount < desDS.Tables[0].Rows.Count; descount++) for (int k = 0; k < (table.Columns.Count - 1); k++)//Ĭ������£������ݱ����һ���ֶξ�ΪtableID��Ϊ�Զ���ţ�������ԶԴ��ֶεĴ��� desDS.Tables[0].Rows[descount][table.Columns[k].ColumnName.ToString()] = table.Rows[i][table.Columns[k].ColumnName.ToString()]; } else//������������� { if (_findthenupdate) { DataRow row = desDS.Tables[0].NewRow(); for (int k = 0; k < (table.Columns.Count - 1); k++) row[table.Columns[k].ColumnName.ToString()] = table.Rows[i][table.Columns[k].ColumnName.ToString()]; desDS.Tables[0].Rows.Add(row); } else { throw new DBKeyViolationException(); } } string s = adapter.UpdateCommand.CommandText; adapter.Update(desDS); } return 0; } else return -3;//δ���ñ��� }
public int Update(MyWebControlLib.FieldValues FV, int tableID) { if (_tablename != "") { DBAccess.DBHelper h = new DBAccess.DBHelper(); SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename); adapter.SelectCommand.CommandText = "select * from " + _tablename + " where tableID=" + tableID.ToString(); DataSet ds = new DataSet(_tablename); adapter.Fill(ds, _tablename); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; for (int i = 0; i < FV.Count; i++) { if (FV[i].Value == null) { row[FV[i].FieldName] = System.DBNull.Value; } else { row[FV[i].FieldName] = FV[i].Value; } } try { adapter.Update(ds, _tablename); return 0; } catch { return -1; } } else //Ϊ�ҵ���ؼ�¼ return -2; } else return -3;//δ���ñ��� }
public int Delete(MyWebControlLib.FieldValues FVS) { if (_tablename != "") { DBAccess.DBHelper h = new DBAccess.DBHelper(); SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename); string condition = " (1=1) "; for (int i = 0; i < FVS.Count; i++) { string values = ""; FVOperater o = FVS[i].FVOperater; switch (o) { case FVOperater.Great: values = " > '" + FVS[i].Value + "' "; break; case FVOperater.Less: values = " < '" + FVS[i].Value + "' "; break; case FVOperater.LikeB: values = " Like '%" + FVS[i].Value + "' "; break; case FVOperater.LikeBE: values = " Like '%" + FVS[i].Value + "%' "; break; case FVOperater.LikeE: values = " Like '" + FVS[i].Value + "%' "; break; case FVOperater.NotGreat: values = " <= '" + FVS[i].Value + "' "; break; case FVOperater.NotLess: values = " >= '" + FVS[i].Value + "' "; break; case FVOperater.In: values = " in (" + FVS[i].Value + ") "; break; case FVOperater.NotIn: values = " not in (" + FVS[i].Value + ") "; break; case FVOperater.NotEqual: values = " <> '" + FVS[i].Value + "' "; break; case FVOperater.Order: break; default: values = " = '" + FVS[i].Value + "' "; break; } condition = condition + _conditionOperater + FVS[i].FieldName + values; } adapter.SelectCommand.CommandText = "select * from " + _tablename + " where " + condition; DataSet ds = new DataSet(_tablename); adapter.Fill(ds, _tablename); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) ds.Tables[0].Rows[i].Delete(); //ʹ��������V2 DBAccess.DBHelper dh = new DBAccess.DBHelper(); dh.Update(ds); //��ʹ��������V1 //adapter.Update(ds,_tablename); return 0; } else return -3; }
public int Updata(DataSet ds) { DBAccess.DBHelper dbhelper = new DBAccess.DBHelper(); if (dbhelper.Update(ds) == 0) { return 0; } else { return 1; } }
public int Add(MyWebControlLib.FieldValues FV) { if (_tablename != "") { DBAccess.DBHelper h = new DBAccess.DBHelper(); SqlDataAdapter adapter = h.GetSqlDataAdapter(_tablename); DataSet ds = new DataSet(_tablename); adapter.Fill(ds, _tablename); DataRow row = ds.Tables[0].NewRow(); for (int i = 0; i < FV.Count; i++) { row[FV[i].FieldName] = FV[i].Value; } ds.Tables[0].Rows.Add(row); try { adapter.Update(ds, _tablename); return 0; } catch { return -1; } } else return -3;//δ�趨���� }